Questions about Exists-Not exists clause

From: papapep <papapep(at)gmx(dot)net>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Questions about Exists-Not exists clause
Date: 2003-07-24 11:30:13
Message-ID: 3F1FC345.50305@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-----

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sanjeev Sharma (Kinera) 2003-07-24 11:37:25 Re: CREATE TYPE with array
Previous Message Stephen Quinney 2003-07-24 09:24:20 Checking for Postgres < 7.3