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

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

I've got, imagine, the next two tables:

table A:

field1    char(3)
field2     varchar(50)
field3     numeric(6)


table B:

field4    date
field5    time
field6    numeric(6)


I need to know which rows in table A are not in table B, and the join
fields are the two numeric ones (field3 and field6).


I've been taking a look at the EXISTS statement, but I can't see how I
should do it.

Some advice??
Thanks in advance.

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

iD8DBQE/H8NE2vx52x0kyz4RAuy0AKCpjWhD04QaHFMICLx/ZWCdzaTfzgCgzHRv
ycw/mHdtnEhY09hgsxc3Qmw=
=SbwX
-----END PGP SIGNATURE-----