SQL select Problem

From: Simon Heinrich <sheinrich_at_hightech-vola.de>
Date: Tue, 10 Sep 2002 13:04:53 +0200
Message-ID: <alkj5k$88j$1@lancelot.camelot.de>

Hi NG,

I like to write an SQL select wich searches in an Collum for a list of Values and also inkludes that collums wich a 'NULL'

SELECT
 "KUNDAT"."KNR", "KUNDAT"."KGR", "KUNDAT"."FNAME1", "KUNDAT"."FNAME2",
"KUNDAT"."FNAME3","KUNDAT"."STR", "KUNDAT"."LAND", "KUNDAT"."PLZ",
"KUNDAT"."ORT","KUNDAT"."POSNR", (SELECT sum ("KUNUMS"."UMS") from
"DSPHTECH"."KUNUMS" "KUNUMS" where "KUNUMS"."JAHR" in (2001,2002) and
"KUNDAT"."POSNR" = "KUNUMS"."PNKUNDAT" ) "Umsatz"
FROM
 "HTECH"."KUNDAT" "KUNDAT",
 "HTECH"."KUNUMS" "KUNUMS"
WHERE

    "KUNDAT"."POSNR" = "KUNUMS"."PNKUNDAT" And
    "KUNDAT"."NR" in ( select "KUNDAT"."KNR" from  "HTECH"."KUNDAT" "KUNDAT"
where "KUNDAT"."KGR" is in
('AM','CG','CG,GI','CG,PM','COMI','COMI-RF+F','DR','ES','GSH','GT','HÄ','HIL
D','IGH','KL','ME','NW','NW-ME','RE','RK','SANIGRO','SED','SU','SU-AUS','SU,

PI','TECHNO','THY','UH,PI','UH,BRICK','UH,H','UH,TAXIS','UH,VMG','VBH','VBH, B','WIEDEMANN','WUP') or "KUNDAT"."KGR" is null)

....but this doesen`t work :(

I hope you can help me.

Simon Received on Tue Sep 10 2002 - 06:04:53 CDT