Hi guys,
What would be the syntax of a join query when you have multiple joins, and need one of them to filter with a 'WHERE'?
E.g.
SELECT Table_A.Name, Table_B.Age, Table_C.Address, Table_D.Gender
FROM Table_A
LEFT JOIN (((Table_B ON Table_A.Name=Table_B.Name)
LEFT JOIN (Table_C ON Table_A.Name=Table_C.Name)
LEFT JOIN (Table_D ON Table_A.Name=Table_D.Name
WHERE Table_D.Name='John')
PS: That's just an example... it's the syntax I'm after.
Much appreciated!
What would be the syntax of a join query when you have multiple joins, and need one of them to filter with a 'WHERE'?
E.g.
SELECT Table_A.Name, Table_B.Age, Table_C.Address, Table_D.Gender
FROM Table_A
LEFT JOIN (((Table_B ON Table_A.Name=Table_B.Name)
LEFT JOIN (Table_C ON Table_A.Name=Table_C.Name)
LEFT JOIN (Table_D ON Table_A.Name=Table_D.Name
WHERE Table_D.Name='John')
PS: That's just an example... it's the syntax I'm after.
Much appreciated!