Re: not enough rows, too many rows, and joins
From: David Cressey <david.cressey_at_earthlink.net>
Date: Thu, 24 Feb 2005 18:27:49 GMT
Message-ID: <F0pTd.6007$Ba3.696_at_newsread2.news.atl.earthlink.net>
Date: Thu, 24 Feb 2005 18:27:49 GMT
Message-ID: <F0pTd.6007$Ba3.696_at_newsread2.news.atl.earthlink.net>
<ford_desperado_at_yahoo.com> wrote in message
news:1109186134.113090.55930_at_g14g2000cwa.googlegroups.com...
> only your 'more correct' solution is not what the OP wants,
> just read:
> "The difficulties include:
> not getting 2 rows for harry (who has 2 vehicles) "
>
> left our join will retrieve an owner of 2 cars twice, which is
> different from the requirements.
>
> Devil is in the details
>
It's not clear to me exactly what the requirements are for Harry.
Harry, male, (red, blue)
In other words, we want 1 row but two colors.... Not so easy in in SQL. Received on Thu Feb 24 2005 - 19:27:49 CET