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
.