Postgres Pro
Downloads
Home   >   mailing lists

Re: Questions about Exists-Not exists clause - Mailing list pgsql-novice

From papapep
Subject Re: Questions about Exists-Not exists clause
Date
Msg-id 3F2108B1.3050908@gmx.net
Whole thread Raw
In response to Re: Questions about Exists-Not exists clause  (Avi Schwartz <avi@CFFtechnologies.com>)
List pgsql-novice
Tree view 
-----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-----

pgsql-novice by date:

Previous
From: "A.Bhuvaneswaran"
Date:
Subject: Re: Get the last record alone from the select statement.
Next
From: Ron Johnson
Date:
Subject: Re: Get the last record alone from the select statement.