Archives of the TeradataForum

Message Posted: Mon, 12 Feb 2007 @ 16:35:46 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

I hope this might be the one what you are looking for.

     update a
     from tab1 a
     ,(select tb1.col1, tb1.col2, tb2.col1 as b
       from tab1 tb1
       left outer join
       tab2 tb2
       on tb1.col1 = tb2.col1
       ) tmp
     set
     col1 = tmp.col1 (or 9999)
     where tmp.b is null;

Let me know if you have any issues.

Thanks

Meher Tej Nimmala

	<Prev	Next>		<<First	<Prev	Next>	Last>>