>>> 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