Posted by Hugo Kornelis on 11/18/05 01:22

On 17 Nov 2005 02:48:04 -0800, Andy Kent wrote:

>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?

Hi Andy,

Can you copy and paste the complete query instead of just a snippet?

Thanks!

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

• Next in forum: Re: Query returning 1.7million records slow
• Prev in forum: Re: Simple SQL Query (To Neglect time from DateTime DataType)
• Thread view: Re: Inner join weirdness in DTS

[Reply to this message]