Display null value
Posted: Tue Oct 27, 2009 2:21 am
Hi,
i do have a join query for 2 tables.i want to display a field as null if it is NULL.how can i do that?Also i have a where condition.what if i want to select value from first table even if the where condition is not satisfied.Mysql version is 5.1
i do have a join query for 2 tables.i want to display a field as null if it is NULL.how can i do that?Also i have a where condition.what if i want to select value from first table even if the where condition is not satisfied.Mysql version is 5.1