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