[thelist] mysql - null - returns results anyway

[Bob Meetin]

r937 wrote:
>> ... 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. 
>
> ORDER BY is ~never~ appropriate for a view
>
> full stop
>
>
> ;o)
>
by view I mean I have a list of 50 or so results and I sort them by 
product name or business name or whatever (order by product name asc).  
is there a different, better method?  this particular db will probably 
have 100, certainly not 200 or so product by various vendors and categories.

-- Bob