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
So registrations looks kinda like:
registration_id bigint (primary key)
and receipts looks like:
receipt_id bigint (primary key)
registration_id bigint (foreign key)
If someone has paid, there is a row in the receipts table for that
I need to find a list of the registration IDs that *don't* have an entry
in the receipts table.
Thanks in advance!!!
mmurrain at dbdes dot com
952-674-7253 fax <--- new
"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
pgsql-sql by date
|Next:||From: Thomas F.O'Connell||Date: 2004-10-08 03:10:33|
|Subject: Re: help on a query|
|Previous:||From: Jaime Casanova||Date: 2004-10-07 20:58:08|
|Subject: Re: Query from different Database|