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 ?