Re: problem with UNION and not in clause

From: "Richard harnden" <harndr@russelleurope.com> > >Thank you, Mr Clown. > >But, you see, I'm wrong. > >Thing is: UNION doesn't return duplicates anyway. >So the whole not in/exists bit is pointless. > >All you actually need is: >select f1, f2 from tableA where f3=1 and f4=2 >and rec_type='CURRENT' >union >select f1, f2 from tableA where f3=1 and f4=2 >and rec_type='PREVIOUS'> > > >>> "Obnoxio The Clown" <obnoxio@hotmail.com> 07/21/00 10:57am >>> >From: "Obnoxio The Clown" <obnoxio@hotmail.com> > > > >I think you could also do this with NOT EXISTS... Hey! All I said was: >Dick's got the best answer... I didn't say which one! :0) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com