Re: SQL - minus

--- "Obnoxio The Clown" <obnoxio@hotmail.com> > wrote: >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? I thought there was an echo in here.... >>--- "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 == Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net