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  Problem JOINing tables

Author  Topic  Judda Starting Member 7 Posts Posted - 2001-09-26 : 08:02:45 Hi there, I have inherited a rather poor database design and I need to perform a double Join, ( I think !) but keep getting an error. There are 3 tables SCHEDULE, COLLPOINTS and DELPOINTS. Schedule has a one to many relation with both of the other tables. There is also a relationship between collpoints and delpoints which I must honour otherwise data gets 'shuffled'. I am using an Access 2000 db with VB6 SP5. The code gives the error different error: Runtime Error '3075' Syntax error (missing operator) in query expression 'schedule.schedid = collpoints.schedid INNER JOIN delpoints ON collpoints.linktodel = delpoints.linktocoll'. DEBUG.PRINT gives :- SELECT * FROM schedule INNER JOIN collpoints ON schedule.schedid = collpoints.schedid INNER JOIN delpoints ON collpoints.linktodel = delpoints.linktocoll WHERE schedule.amdriver = 'Z1' AND schedule.[datetextkey] >= '20010726' AND schedule.[datetextkey] <='20010729' ORDER by [datetextkey] Please help if you can. Thanks Judda