[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