Steve Eckerman
asked on
SQL Query Problem
I have a query where I am trying to update a field to the new fiscal year with the matching field from the old fiscal year. It looks like this but it does not work. Any ideas?
UPDATE [SELECT Mgr, PSINO, FiscalYear FROM PartForecast WHERE FiscalYear=2013; ] AS A INNER JOIN [SELECT Mgr, PSINO, FiscalYear FROM PartForecast WHERE FiscalYear=2012; ] AS B ON A.PSINO=B.PSINO SET A.Mgr = B.Mgr;
UPDATE [SELECT Mgr, PSINO, FiscalYear FROM PartForecast WHERE FiscalYear=2013; ] AS A INNER JOIN [SELECT Mgr, PSINO, FiscalYear FROM PartForecast WHERE FiscalYear=2012; ] AS B ON A.PSINO=B.PSINO SET A.Mgr = B.Mgr;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That is correct.
ASKER
Great Answer! Worked like a champ!!! Thanks!!!
ASKER