InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:07:17 GMT20http://www.teradata.com/teradataforum/Topic9874-9-1.aspxThe following sql will workupdate target.tablefrom( select lkptable.clm1 x,srctable.clm2 y from lkptable,srctablewhere lkp.clm3=src.clm3lkp.clm4=src.clm4lkp.clm5=src.clm5lkp.clm6=src.clm6lkp.clm7=src.clm7lkp.clm8=src.clm8)cset clm1 = c.xwhere clm2 = c.yWed, 28 Nov 2007 13:58:26 GMTvundisrinivashttp://www.teradata.com/teradataforum/Topic9874-9-1.aspxFrom your question I didn't get what you are looking for.. You may try this logic.. that should work..update targetSET clm1 = lkp.clm1WHERE EXISTS ( Select 1 from lkp,src where lkp.clm3=src.clm3 lkp.clm4=src.clm4 lkp.clm5=src.clm5 lkp.clm6=src.clm6 lkp.clm7=src.clm7 lkp.clm8=src.clm8)Tue, 27 Nov 2007 18:11:24 GMTSomeshhttp://www.teradata.com/teradataforum/Topic9874-9-1.aspxI need to updata column in target table.1. source table2. Lkp table3. target tablethe query i wrote is not working can any one help me out.update target.tablefrom( select lkptable.clm1,srctable.clm2 from lkptable,srctablewhere lkp.clm3=src.clm3 lkp.clm4=src.clm4 lkp.clm5=src.clm5 lkp.clm6=src.clm6 lkp.clm7=src.clm7 lkp.clm8=src.clm8) as cset target.clm1 = c.clm1where target.clm2 = c.clm2Tue, 27 Nov 2007 12:34:34 GMTskdasari