[thelist] mysql - null - returns results anyway

Phil Turmel pturmel-webdev at turmel.org
Tue Dec 22 16:19:58 CST 2009


On 12/21/2009 07:26 PM, r937 wrote:
> nice one phil

Thanks.
> 
> i personally would not parenthesize the joins
> 
> (you must have picked up that bad habit from ms access)

Heh.  It's been years, but guilty as charged.
> 
> and if there's only one vendor being selected, there's not much point in
> sorting on the vendor name

True enough, but I often find myself using these sorts of
quick-and-dirty queries as the basis for views, in which case the extra
"order by" is useful and appropriate.  And I'm a creature of habit.

Phil


More information about the thelist mailing list