Re: not enough rows, too many rows, and joins
From: <ford_desperado_at_yahoo.com>
Date: 23 Feb 2005 11:15:34 -0800
Message-ID: <1109186134.113090.55930_at_g14g2000cwa.googlegroups.com>
Date: 23 Feb 2005 11:15:34 -0800
Message-ID: <1109186134.113090.55930_at_g14g2000cwa.googlegroups.com>
only your 'more correct' solution is not what the OP wants,
just read:
left our join will retrieve an owner of 2 cars twice, which is
different from the requirements.
"The difficulties include:
not getting 2 rows for harry (who has 2 vehicles) "
Devil is in the details Received on Wed Feb 23 2005 - 20:15:34 CET