SQL query question

From: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: "Pgsql-General (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: SQL query question
Date: 2004-12-22 12:50:18
Message-ID: A3D1526C98B7C1409A687E0943EAC41048A044@obelix.askesis.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I have 2 tables, with a 1-n relation:

parent( oid, parent_name)
child(oid, child_name, iod_parent)

How do I get the parent_names of all parents without a child?

TIA

Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Postgres Learner 2004-12-22 13:00:42 Re: weird run-times with pg_autovacuum
Previous Message SoftHome 2004-12-22 12:45:35 REMOVER