Problem with Left Join in Access 97

[wendywam]

Hi All
How do i convert the following sql 6.5 query into Ms Access 97 query.

SELECT a.Rem,b.nam,c.Pro,d.Exp,e.Fligh
FROM
Table1 a
LEFT OUTER JOIN Table2 b ON b.Code = a.Cone
LEFT OUTER JOIN Table3 e ON e.AwbN = a.AwbN
LEFT OUTER JOIN Table4 c ON c.AwbN = a.AwbN
LEFT OUTER JOIN Table5 ON d.AwbN = a.AwbN
WHERE a.AwbN = '12345'

 

[BNPMike]

Take out the 'Outer' and group joins with brackets.

Better still go into QBE, bring in the 5 tables, join them visually, edit the join lines (to be effectively left joins) and sit back while Access does the work of generating correct SQL.

Don't have a dog and bark yourself.