Dubbel join

Hur gör man en dubbel join ? Är syntaxen fel.

Försöker med följande:

sql = "SELECT * FROM T_staff "
sql = sql & " LEFT JOIN T_department ON "
sql = sql & " T_staff.department_id = T_department.ID "
sql = sql & " AND "
sql = sql & " LEFT JOIN T_business_unit ON "
sql = sql & " T_staff.business_unit_id = T_business_unit.ID "

Ger...

Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression ''.

/staffdatabase2/show_vcard.asp, line 24

Du ska inte ha AND mellan dina joiner. Dessutom; eftersom du kör Access blir det lite laborerande med parenteser om joinen ska gå igenom.

sql = "SELECT * FROM (T_staff "
sql = sql & " LEFT JOIN T_department ON "
sql = sql & " T_staff.department_id = T_department.ID) "
sql = sql & " LEFT JOIN T_business_unit ON "
sql = sql & " T_staff.business_unit_id = T_business_unit.ID "

Ok. Jag förstår. Hur ser det ut med paranteserna om jag vill ha ytterligare en join, dvs 3?

Tack för insatsen @nders.

Bode bli så här:

sql = "SELECT * FROM ((T_staff "
sql = sql & " LEFT JOIN T_department ON "
sql = sql & " T_staff.department_id = T_department.ID) "
sql = sql & " LEFT JOIN T_business_unit ON "
sql = sql & " T_staff.business_unit_id = T_business_unit.ID) " 
sql = sql & " LEFT JOIN T_fjuk ON T_fjuk.fjukID = T_business.fjukID"

Ok. Då är jag med i matchen. Tackar.