Skip to Content
0
Former Member
Mar 19, 2009 at 02:44 PM

SELECT WITH ISNULL

560 Views

SELECT ISNULL(tabA-Col1, tab-Col2) AS Col

FROM tabA INNER JOIN tabB

ON .....

If Col1 from table tabA is null, then I need to get Col2 from table tabB.

How can I make this query work ?