Cannot find input table

[sundarv]

hi
i'm trying to link 2 tables in different databases using DAO. i'm issuing the following sql statement.

"select demo.prodid,demo.name,mark.flag from
demo,mark IN "C:\bookmark.mdb" where demo.prodid=mark.id;

when i run this query, it says 'can't find output table demo'

any one in the group

reply

[Chris]

try to use LEFT JOIN or RIGHT JOIN SQL Statement for your case.

Cheers!