Sono in questo caso qui :
codice:
UPDATE Email_List,Utenti SET Email_List.Coda_MailList='/1849941873/' WHERE ( Email_List.Dominio LIKE '%/ADMIN/%' OR Email_List.Dominio LIKE '%/C/%' OR Email_List.Dominio LIKE '%/E/%' OR Email_List.Dominio LIKE '%/G/%' OR Email_List.Dominio LIKE '%/I/%' OR Email_List.Dominio LIKE '%/L/%' ) AND Email_List.Eliminato_MailList=0 AND Email_List.Eliminato=0 AND Utenti.Eliminato=0 AND Utenti.Email=Email_List.Email AND (Email_List.Coda_MailList Is Null OR Email_List.Coda_MailList='');
Mi genera questo errore :
codice:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near ','.
email_campagne_new_wplus_edit.asp, line 665
Devo aggiornare una tebella con de record ma la condizione mi include anche la verifica su un'altra tabella.
Mentre se faccio così :
codice:
SQL=UPDATE Email_List SET Email_List.Coda_MailList='/1849941873/' WHERE ( Email_List.Dominio LIKE '%/ADMIN/%' OR Email_List.Dominio LIKE '%/C/%' OR Email_List.Dominio LIKE '%/E/%' OR Email_List.Dominio LIKE '%/G/%' OR Email_List.Dominio LIKE '%/I/%' OR Email_List.Dominio LIKE '%/L/%' ) AND Email_List.Eliminato_MailList=0 AND Email_List.Eliminato=0 AND Utenti.Eliminato=0 AND Utenti.Email=Email_List.Email AND (Email_List.Coda_MailList Is Null OR Email_List.Coda_MailList='');
Mi genera questo errore:
codice:
Microsoft OLE DB Provider for SQL Server error '80040e14'
The column prefix 'Utenti' does not match with a table name or alias name used in the query.
email_campagne_new_wplus_edit.asp, line 665
Come risolvo?