--- In firebird-support@yahoogroups.com, 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