[thelist] mysql - null - returns results anyway

[Bob Meetin]

r937 wrote:
> nice one phil
>
> i personally would not parenthesize the joins
>
> (you must have picked up that bad habit from ms access)
>
> and if there's only one vendor being selected, there's not much point 
> in sorting on the vendor name
>
> SELECT p3_products.id             AS pid
>     , p3_products.name           AS product_name
>     , p3_vendors.name            AS vendor_name
>     , p3_product_categories.name AS category_name
>     , p3_products.jos_content_id AS product_jos_content_id
>     , p3_vendors.jos_content_id  AS vendor_jos_content_id
>     , p3_product_categories.jos_content_id AS category_jos_content_id
>  FROM p3_vendors
> LEFT OUTER
>  JOIN p3_products
>    ON p3_products.vendor_id = p3_vendors.id
> LEFT OUTER
>  JOIN p3_product_categories
>    ON p3_product_categories.id = p3_products.category_id
> WHERE p3_vendors.id = '21'
> ORDER
>    BY product_name ASC
>
> ;o)
>
>
> rudy
> http://simply-sql.com/
>
I will try this as well; with Phil's help Christmas came early.  Much 
X-thanx.

What is not seen here is that there are multiple where/and options.  In 
some cases the vendor id is not specified, so the order by helps there.  
I have other options that come into their own if the viewer specifies.  
Still, in my mind I was thinking something incorporating 'is null', not 
/dev/null...