Questa query non vuole funzionare e non capisco perchè:
codice:
sql1 = "select distinct lam.id_cm as codice, cm.cm as BlocScorr from lam inner join cm on lam.id_cm = cm.id_cm WHERE lam.id_at = "&at&" "
mi restituisce
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'cm'. Make sure it exists and that its name is spelled correctly.
Grazie