>>> I wrote: > You've got a name, and you want a list of outstanding warrants for > parties with a matching name. Correction, if that was the list you wanted, you would use an inner join, not a semijoin. For purposes of this illustration I guess you would be looking for a list of parties who have outstanding warrants, not a list of the warrants themselves. -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers