FROM table1LEFT JOIN table3 ON table2.key = table3.keyFROM table1 LEFT JOIN table3ON table1.key = table2我决定添加一个更复杂的第二类示例:
SELECT table1.Name AS MainData, table3P
类型推断在调用'Join'.时失败 join jd in db.JobDetail on jh.number equalsjd.number
joinjs in db.JobSection on new { jd.number, jd.ref, jd.product } equals new{ js.number, js.ref, js
as 'Dept', ST.ST_NoteText AS 'Note Text' LEFT JOIN Company gc (NOLOCK)on st.st_gc_relatedCompany = gc.gc_pk
LEFT JOIN jobshipment js (NOLOCK) ON st.ST_ParentID = js.JS_PKLEFT JOIN jobheader jh