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? George Perolli Director - IS Department Traffic Tech Inc. Tel: (514) 343-0044 Fax: (514) 343-0045 mailto:[EMAIL PROTECTED] --------------------------------------------------------------------- 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
