Postgres Pro
Downloads
Home   >   mailing lists

SQL query question - Mailing list pgsql-general

From Joost Kraaijeveld
Subject SQL query question
Date
Msg-id A3D1526C98B7C1409A687E0943EAC41048A044@obelix.askesis.nl
Whole thread Raw
Responses Re: SQL query question
List pgsql-general
Tree view 
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.Kraaijeveld@Askesis.nl
web: www.askesis.nl

pgsql-general by date:

Previous
From: "SoftHome"
Date:
Subject: REMOVER
Next
From: Postgres Learner
Date:
Subject: Re: weird run-times with pg_autovacuum