Re: Informix Help

-=> Quoting Stuart Litel to All <=- SL> table a SL> x char(10) SL> y smallint SL> table b SL> x char(10) SL> y smallint SL> You want to find all the rows in table a were there is an "x in table SL> a and no coorresponding "x" in table b the query would be: SL> select rowid from a where x not in (select x from b) SL> Now the question - how do you find all the x and y combinations in SL> table a where they are not in table b. Try this: select rowid from a where x not in (select x from b) union select rowid from a where y not in (select y from b) Bill Williams ... DOS never says "EXCELLENT command or filename"... ___ Blue Wave/QWK v2.12 ---- +------------------------------------------------------------------------+ | Data Warp Premium BBS (713) 355-6107 HST/V.32bis | | Spring / Houston, Texas Multi-line, multi-gig PCBoard BBS | +------------------------------------------------------------------------+