UPDATE a
SET a.[TxnNumGUID] = b.[trans_num]
from
table1 a
Inner Join
Table2 b
on a.Linkingfield = b.Linkingfield
Inner Join
Table 3 c
on b.Ref_Num = c.po_Num
WHERE table2.[ref_type] = 'P' 

quote:

---

Originally posted by theladycoder

The thing is that table1 is accepting data from table2, but table2.ref_num needs to equal table3.po_num to update the correct value for table1.transNumGUID, which is found in table2. So, your inner join table2 on a.linkfield = b.linkfield would not work. I just can't seem to get my head wrapped around this one. Thanks in advance

---

Update a
set 
a.PartnerID = Coalesce(a.PartnerID , 'xxxxxx')
,a.EffDate =Coalesce(a.EffDate ,REPLACE(REPLACE(REPLACE(REPLACE(CONVERT(varchar(20), GETDATE(), 126),' ','T'),'-',''),':',''),'.','') )
,a.SpiCode1Source = Coalesce(a.SpiCode1Source , 'I') 
,a.SpiCode2Source =Coalesce(a.SpiCode2Source , 'I') 
,a.RelationshipFlagSource = Coalesce(a.RelationshipFlagSource , 'I') 
,a.HTSDescSource = Coalesce(a.HTSDescSource , 'I') 
,a.HTSNum2Source = Coalesce(a.HTSNum2Source , 'I') 
,a.Value2 = Coalesce(a.Value2 , '0' )
,a.CurrencyCode = Coalesce(a.CurrencyCode , 'USD' )
,a.AltValue = Coalesce(a.AltValue , '0' )
,a.AltValue2 =Coalesce(a.AltValue2 , '0' )
,a.AltCurrencyCodeSource = Coalesce(a.AltCurrencyCodeSource , 'I')
,a.AdValoremRateSource = Coalesce(a.AdValoremRateSource , 'I') 
,a.SpecificRateSource =Coalesce(a.SpecificRateSource , 'I')
,a.HtsUomConvFactor =Coalesce(a.HtsUomConvFactor , '0')
,a.HtsUomConvFactorSource =Coalesce(a.HtsUomConvFactorSource , 'I') 
,a.Add1HtsUomConvFactor =Coalesce(a.AddlHtsUomConvFactor , '0' )
,a.Add1HTSUomConvFactorSource =Coalesce(a.AddlHtsUomConvFactorSource , 'I')
,a.RptQtyUomSource = Coalesce(a.RptQtyUomSource , 'I') 
,a.Add1RptQtyUomSource = Coalesce(a.AddlRptQtyUomSource , 'I') 
,a.Add1SpecificRateSource = Coalesce(a.AddlSpecificRateSource , 'I') 
,a.AdDutyRate = Coalesce(a.AdDutyRate , '0' )
,a.AdDutyRateSource = Coalesce(a.AdDutyRateSource , 'I') 
,a.AdCaseNum = Coalesce(a.AdCaseNum berSource , 'I') 
,a.CVDutyRate = Coalesce(a.CVDutyRate , '0' )
,a.CVDutyRateSource =Coalesce(a.CVDutyRateSource , 'I')
,a.CVCaseNumberSource = Coalesce(a.CVCaseNumberSource , 'I') 
,a.RC021Source = Coalesce(a.RCO21Source , 'I') 
,a.Rco22Source = Coalesce(a.RCO22Source , 'I') 
,a.RC023Source =Coalesce(a.RCO23Source , 'I') 
from
MQG_FIFO_Processing_HTS_Values_Export a