Re: Accountability with MySQL

[Martijn Tonies]

James,


> Also, surely if you left join to a table then if there's no matching row
you get a null value in your result set. So I'm not sure what the difference
is between getting that null because you store it in a column in the primary
table, and deriving it by left joining to a related table with no matching
rows.

Handling nulls in your resultsets makes a heck of a
lot more sense than also storing these NULLs :-)



Martijn Tonies
Upscene Productions
http://www.upscene.com