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??
Danke
Babsi
~~~~~~~~~~~~~~~~~~~~~~~~~~~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
