From: Martijn Tonies
Date: March 16 2006 12:05pm
Subject: Re: Accountability with MySQL
List-Archive: http://lists.mysql.com/mysql/195886
Message-Id: <01bd01c648f1$f1ad4320$cd02a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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