--- In [email protected], Mark Rotteveel <mark@...> wrote: > > One more question Mark. Will > > WHERE EXISTS (SELECT 1 FROM tableb b WHERE b.iPKID<> a.iTableBLinkID) > > > > be more efficient as the<> records will be far less over the time or does > > that interfere with using indices? > > That is a totally different select and will have an entirely different > result than the one you desire. > > Mark > -- > Mark Rotteveel >
Yes, you are right Mark. I had tried it, did not work as intended. Thanks and regards Bhavbhuti
