Re: SQL - minus

Try using NOT IN as in 'WHERE e.code NOT IN' followed by your subquery. --- "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