This is a bit vague. How about showing what you have done, and how it is not what you wan't.
Colleen Dick wrote:
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]