From: Michelle Murrain <tech@murrain.net>
To: pgsql-sql@postgresql.org
Subject: help on a query
Date: Thu, 07 Oct 2004 23:03:07 -0400
Message-ID: <4166036B.1020001@murrain.net> (raw)
Hi all,
This is one of those things I know I should know, but it's not coming to
me. It's probably really simple.
I have two related tables, registrations and receipts, related by the
field registration_id.
So registrations looks kinda like:
registration_id bigint (primary key)
foo varchar(10)
bar varchar(20)
and receipts looks like:
receipt_id bigint (primary key)
registration_id bigint (foreign key)
amount float
baz varchar(10)
If someone has paid, there is a row in the receipts table for that
registration ID#.
I need to find a list of the registration IDs that *don't* have an entry
in the receipts table.
Thanks in advance!!!
--
.Michelle
--------------------------
Michelle Murrain
mmurrain at dbdes dot com
413-222-6350 ph
617-889-0929 ph
952-674-7253 fax <--- new
Page: pageme@murrain.net
AIM:pearlbear0 ICQ:129250575
Skype: pearlbear
Jabber: pearlbear@transactim.net
"I see all the different religious traditions as paths for the
development of inner peace, which is the true foundation of world peace.
These ancient traditions come to us as a gift from our common past. Will
we continue to cherish it as a gift and hand it over to the future
generations as a legacy of our shared desire for peace?" - His Holiness
the Dalai Lama
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tech@murrain.net
Subject: Re: help on a query
In-Reply-To: <4166036B.1020001@murrain.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox