April 5, 2011 at 9:24 am
Hi,
I made a table out of joins of 2-3 tables..
In 2-3 columns of my resulting table, I am getting blank ( no result)
The sql server shows it as NULL.
But When i query it as
select * from table
where columnname ='NULL'
it doesnt show those rows as its empty not NULL value...
I want to see such values..
How to do it
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
April 5, 2011 at 9:33 am
1 - SELECT * FROM table where Column IS NULL
2 - Are you using left joins? That could cause the same issue.
April 5, 2011 at 9:59 am
Ninja's_RGR'us (4/5/2011)
1 - SELECT * FROM table where Column IS NULL2 - Are you using left joins? That could cause the same issue.
Yes, tht did d trick...
Yes, i am using left joins, because of the nature of result i want...
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply