Re: Questions about Exists-Not exists clause

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Many, many thanks to all who have answered.
It works fine (and fast) with the:

SELECT * FROM A WHERE NOT EXISTS (SELECT NULL FROM B WHERE
A.field3=B.field6);

Josep Sànchez
~ [papapep]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/IQiv2vx52x0kyz4RAn4hAJ9snDZGCrmmU1NauvdoQqVDiHM1AQCgho8W
DkxWzW4jl7ddXa137oz/Im8=
=CMDZ
-----END PGP SIGNATURE-----