Barry wrote:
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
For that read also optimizing LEFT JOINs on dev.mysql.com
Ok. That's for me today.
Going home. Cya around ;)
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]
