select b.emailaddress, a.companykey, a.customerid, b.lastname from ispcustomer a
inner join ispcontact b on a.billingcontactkey = b.contactkey
where a.status = 'N' or a.status = 'A' and a.customerid not in {50045 ,50142 ,50188 ,50233}
Ich hab's jetzt so und es kommt trotzdem der selbe fehler??
Wie w�r's mal mit () statt {}?
Chris
~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~ Intrexx.BizWalker + ODBC/OLEDB-Daten = ASP-Formular ATTACK! Download Intrexx CRM-Studio Now! http://www.intrexx.com _______________________________________________ Database.asp mailing list [EMAIL PROTECTED] http://www.glengamoi.com/mailman/listinfo/database.asp
