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 is not in {"50045" ,"50142"
,"50188" ,"50233" ,"50280" ,"50325" ,"50372" ,"50415" ,"50460" ,"50506" ,"50552"
,"50599" ,"50646" ,"50743" ,"50796" ,"50846" ,"50893" ,"50948" ,"0033951" ,"0005308"
,"50002" ,"50005" ,"50007" ,"50008" ,"50009" ,"50010" ,"50013" ,"50015" ,"50016"
,"50017" ,"50018" ,"50019" ,"50020" ,"50021" ,"50022" ,"50023" ,"50025" ,"50026"
,"50028" ,"50029" ,"50030" ,"50032" ,"50033" ,"50034" ,"50035" ,"50036" ,"50037"
,"50038" ,"50039" ,"50040" ,"50041" ,"50042" ,"50044" ,"0005310" ,"40002" ,"40003"
,"40004" ,"40005" ,"40008" ,"40012" ,"40011" ,"40014" ,"40015" ,"40016" ,"40017"
,"40018" ,"40019" ,"40020" ,"40021" ,"40023" ,"40024" ,"40026" ,"40028" ,"40029"
,"40030" ,"40031" ,"40032" ,"40033" ,"40035" ,"40036" ,"40037" ,"40038" ,"40039"
,"40040" ,"40041" ,"40042" ,"40044" ,"40046" ,"40047" ,"40048" ,"40049" ,"50553"
,"50555" ,"50556" ,"50557" ,"50558" ,"50559" ,"50560" ,"50561" ,"50562" ,"50564"
,"50567"!
,"50568" ,"50569" ,"50570" ,"50573" ,"50574" ,"50575" ,"50576" ,"50577" ,"50578"
,"50579" ,"50580" ,"50581" ,"50582" ,"50583" ,"50584" ,"50585" ,"50586" ,"50587"
,"50588" ,"50590" ,"50592" ,"50593" ,"50595" ,"50596" ,"50598" ,"50600" ,"50601"
,"50602" ,"50603" ,"50604" ,"50605" ,"50607" ,"50608" ,"50612" ,"50613" ,"50615"
,"50616" ,"50617" ,"50618" ,"50620" ,"50621" ,"50622" ,"50623" ,"50625" ,"50626"
,"50627" ,"50629" ,"50633"}
Ich bekomme folgenden Fehler:
[Microsoft][ODBC SQL Server Driver]Syntax error or access violation
Was mache ich falsche?
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
