SQL-Fehler bei MSSQL

[Sharky]

Hai alcaeus,

hast Du einmal versucht deine ganzen WHERE-Bedingungen in Klammern zu setzen

SQL-Code:

SELECT N.TEXT,A.AUTHORIZEDGROUPS FROM PAYMENTTERMS A,NLSUSER N 
WHERE (A.MANDANTID=0)
AND ((A.AUTHORIZEDGROUPS IS NULL) OR (0=0) OR (';0;' IN A.AUTHORIZEDGROUPS))
AND (N.LANGUAGEID=0)
AND (N.TOPICID=18)
AND (N.FIELDID=A.NLSFIELDID)