"Alexey Petrovsky" <[EMAIL PROTECTED]> wrote: > select e164 from lcr15 except select e164 from lcr16 order by ... > > select e164 from lcr15 where e164 not in (select e164 from lcr16) ... > > ... > I thought that those queries provide the same result. > ... > Any guess? > > Alexey.
It's not necessary to guess. The results are correct. The first query produces a set difference; the second selects all rows that satisfy the where clause; they are not the same. An equivalent for your first query is select distinct e164 from lcr15 where e164 not in (select ...) Regards
