Hi guys

can anyone tell me why this doesn't work:

select siteid, sitename
from tblSiteDetails
where siteid in (select siteid from
"f:\inetpub\wwwroot\data_NewSystem\spndm_log.mdb".tblenquirydetails)
order by sitename

the path to the DB is correct. The error I get is "Type mismatch in
expression"

Thanks

Giles


-- 
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]

Reply via email to