I'm using a access 2000 db and I'm trying to get information from 1 table and also a second table, if the second table does not have records related to the first table it's ok, just select the fields. But right now i'm getting this error if i use the 'cb.cd_lay = 0':
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Join expression not supported.
My SQL statement is: SELECT * FROM lays l INNER JOIN cont_box cb ON cb.cd_lay = 1 WHERE l.cd_lay = 1
if i use 'cb.cd_lay = l.cd_lay' then i get a empty rs, but the table lay has a record with the cd_lay value of '1'