I guess i was going in the wrong direction totally.

say there are three rows in table B whose col1 value is greater than 1000.

these three rows in table B will...

hi ALZDBA,

Let me make my requirement more specfic.

I have to perform left outer join between table a and table b.

now we know that there can be rows in 'table b'...

hey thanks.

I shall try out isnull tomorrow in office.

Isnull will check the returned value is null or not.

what is I have to check two conditions.

I need to check whether the...