Display null value

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
GinsBabu
Forum Newbie
Posts: 8
Joined: Sat Oct 24, 2009 7:00 am

Display null value

Post by GinsBabu »

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
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: Display null value

Post by VladSun »

There are 10 types of people in this world, those who understand binary and those who don't
Post Reply