|
|
Archives of the TeradataForum
Message Posted: Mon, 12 Feb 2007 @ 15:09:09 GMT
Subj: | | Re: Update with left outer join |
|
From: | | Victor Sokovin |
| You are trying to do a join on a column where it is Null. This will never work. Perhaps you meant "is not Null"? | |
Randy, may I suggest you run the following two statements?
sel *
from (select 1 A ) D1 left outer join (select 1 A ) D2 on D1.A = D2.A
where D2.A is null
sel *
from (select 1 A ) D1 left outer join (select 2 A ) D2 on D1.A = D2.A
where D2.A is null
Have you changed your opinion?
Good.
Regards,
Victor
| |