tricky query

[Colleen Dick]

I am building a SELECT using a left join and I almost have what I want.

One of the fields that gets sucked in from the left join is either null 
or has a value in it.

if it is null I only want to include the rows from the main table where 
the field isdemo=1

if that field has a value in it I want all the rows that match otherwise.

Is there any way to do it all in one query?



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]