Chris Sansom wrote:
Yeah - it certainly seems promising. Better do some more reading!
Japanese say here: Ganbatte! (Do your best!)
Hmmm - now you've confused me a bit. Quoting from the section in the
DuBois book:
"...a LEFT JOIN forces the result set to contain a row for every row in
the left side table, whether or not there is a match for it in the right
side table"
...which isn't necessarily what I want in all cases.
Well Internally he does that, but with additional WHERE clauses you can
only have those columns LEFT JOINed you necessarily want.
Without WHERE he would exactly do what Mr. DuBois said.
Greets
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
