oops, sorry, übersehen - Du hast geschweifte Klammern statt normale..
Also:
and a.customerid not in (50045 ,50142 ,50188 ,50233)
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 02, 2003 11:14 AM
Subject: [Database.asp] hmm
>
> 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
~~~~~~~~~~~~~~~~~~~~~~~~~~~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
