Posted by Andy Kent on 11/17/05 12:48

I am trying to import data from Access 2000 in SQL Server 2000 using
DTS. One of the tasks requires a multi-table join but I am getting
syntax errors if I generate the query with Build Query.

With just a single join like this it works fine:

FROM Tracker INNER JOIN
bdmanager ON Tracker.bdmanager = bdmanager.name,
country

But as soon as I get it to generate an extra join, e.g.

FROM Tracker INNER JOIN
bdmanager ON Tracker.bdmanager = bdmanager.name
INNER JOIN
country ON Tracker.country = country.country

.... I get "sytax error (missing operator)". The weird thing is that it
generated the syntax itself!
I can paste the query into Access and it works fine.

Why is this happening and what's the best workaround?

Thanks

Andy

• Next in forum: What looks like a basic SQL query still not resolved
• Prev in forum: Re: sql query update
• Thread view: Inner join weirdness in DTS

[Reply to this message]