Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  multiple joins in access 2000

Author  Topic  alexmac Starting Member 8 Posts Posted - 2001-11-21 : 09:47:01 Hi I need to return data from 4 different tables. 3 of the tables are related by the foreign key (clientID) to customerTbl. There will not always be related data in the other tables for each customer, I am thus using a left join. The statement I am using is below: SELECT customerTbl.title, customerTbl.firstname, customerTbl.surname, syndicatePurchaseTbl.syndicatedateProceed FROM customerTbl LEFT JOIN syndicatePurchaseTbl ON customerTbl.clientID=syndicatePurchaseTbl.clientID LEFT JOIN housePurchaseTbl ON customerTbl.clientID=housePurchaseTbl.clientID When I use just one leftJoin it works fine but with more than that Access returns the error "missing operator". Any ideas? Thanks Alex