Re: not enough rows, too many rows, and joins
Date: Thu, 24 Feb 2005 19:35:09 GMT
Message-ID: <N%pTd.6119$Ba3.4514_at_newsread2.news.atl.earthlink.net>
"David Cressey" <david.cressey_at_earthlink.net> wrote in message
news: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.
>
>
Oops, my mistake. I thought Harry had two cars. (Bad short term memory). Received on Thu Feb 24 2005 - 20:35:09 CET