dynamicjourney2001
Programmer
Hi,
I want to display a blank row when my query returns 0 result. i have accomplished this using a UNION clause,
Select col1 from table where col1 = 1
Union select '' where not exists (select col1 from table
where col1 = 1)
but Im curious on how it could be handled w/o using a union.
Thanks in advance guys.
Have fun!