Archives of the TeradataForum
Message Posted: Mon, 12 Feb 2007 @ 17:59:35 GMT
<-- Anonymously Posted: Monday, February 12, 2007 12:43 -->
Without considering the validity of your logic, here is what you can do.
update tab1 a from (select aa.col1 from tab1 aa Left outer join tab2 bb on a.col1 = b.col1 where b.col1 is null) b set col1 = 999 Where a.col1 = b.col1 ;
Hope this helps.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|