The following select statement works using BDE but when I run a ADO query I get a error message - trying to change old programs from using bde to ado. -Syntax error (missing operator) in query expression 'messtbl.book_id = books.book_id left join spkr ON spkr.spkr_id = messtbl.spkr_id'-
Select mess_id, sponsor, mess_title, dte, tape_num, video_loc, cas_loc, book, scriptue, spkr_id, l_name from messtbl left join books ON messtbl.book_id = books.book_id left join spkr ON spkr.spkr_id = messtbl.spkr_id where Sponsor like '%no one%' order by tape_num returns two rows using BDE which is correct. If I drop the second join the ado query works but I need the second join to get l_name field. Any suggestions been trying google for over a week now every example I see looks like what I am doing. Thanks Tony ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/delphi-en/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
