Re: SQL - minus

From: "Pietje Puk" <Pietje@puk.com> > >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? Having flicked through the manual, it appears that Informix does not support this, so you're going to have to do it another way, perhaps something like: select e.code from table_1 e where e.code like 'D%' and e.code not in ( select g.code from table_2 g where g.code like 'D%' ) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com