UPDATE query multipart idnetifier error 1

[vba317]

I am using SQL 2005. My query isn't working. I keep on getting the following error. The multi-part identifier "Pd.Mon_shnm" could not be bound. I am trying to use information from the dbo.dic_Period table and put it into the dbo.rpt_FYInfo table.

Tom

UPDATE rptdata_monthly.dbo.rpt_FYInfo
set mon_shnm = pd.mon_shnm
SELECT pd.mon_shnm
FROM rptdata_monthly.dbo.dic_Period pd
INNER JOIN rptdata_monthly.dbo.rpt_FYInfo FY ON FY.rptpd = pd.pd
WHERE FY.rptpd = 391 and FY.uci='BPA' and FY.mon_shnm is null

 

[imex]

Try:

UPDATE FY
set FY.mon_shnm = pd.mon_shnm
FROM rptdata_monthly.dbo.rpt_FYInfo FY 
INNER JOIN rptdata_monthly.dbo.dic_Period pd
    ON pd.pd = FY.rptpd 
WHERE 
    FY.rptpd = 391 and 
    FY.uci='BPA' and 
    FY.mon_shnm is null

Hope this helps.

[URL unfurl="true"]http://www.imoveisemexposicao.com.br/imobiliarias-em-guarulhos[/url]

 

[vba317]

Thanks this worked like a charm. I am going to have to update another 6 fields with this concept so I really appreciate your help!

Tom