George Perolli wrote:
>I used the Query Designer in Access to create the following query:
>
>SELECT Docs214.BOL, Docs214Dates.Date
>FROM Docs214Dates
>INNER JOIN (Docs214Picks INNER JOIN Docs214 ON Docs214Picks.DocID =
>Docs214.UniID) ON Docs214Dates.DocID = Docs214Picks.UniID
>WHERE Docs214Dates.Type = 1 AND Docs214Picks.LoadNum = 'LDS0135686'
>
>When I run this in Access2000 threw the MyODBC driver it runs fine.
>When I use the same query in a VB6 app it returns a syntax error at the
>first open bracket.
>
>Does anyone have any ideas?
>
>
Sure, simply leave the brackets away.
Greetings
Ralf
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROTECTED], http://www.splendid.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
