Re: SQL - minus

From: Carlos Benjamin <benj@firstlinux.net> > >Try using NOT IN as in 'WHERE e.code NOT IN' followed by your subquery. Didn't I just say that? >--- "Pietje Puk" <Pietje@puk.com> > > wrote: > >Hi All, > > > >I've got two customertables, just a little bit different. > >I want to know/see only the custmores that i am missing in the second >table. > > > >In Oracle or SQL-server the syntax is something like: > > > >select e.code > >from table_1 e > >where e.code like 'D%'> >minus > >select g.code > >from table_2 g > >where g.code like 'D%'> > > >What is the syntax for "MINUS" in Informix? > > > >Or doesn't Informix support this? > > > >Allready thanks > > > >Alex > >== >Maintainer of the procrastinator's FAQ. > Well, maybe tomorrow I will be. > >_____________________________________________________________ >Want a new web-based email account ? ---> http://www.firstlinux.net ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com