Error when Updating Records in the Same Table using a SQL Update Query

[mbryan]

I have the following SQL code and I am getting a error that simply states

​

Syntax Error in query expression ".

It then highlights the P in the middle of the code.

Here is the code and any help in determining the source of the error is appreciated. Thanks,

UPDATE RollInfo 

INNER JOIN RollInfo 

AS RollInfo_1 

ON (RollInfo.PalletNo = RollInfo_1.PalletNo) AND (RollInfo.PackListNo = RollInfo _1.PackListNo) 

SET RollInfo.PackageNo = [RollInfo _1].[GBN_Fin_Roll_ID]

WHERE (([RollInfo _1].[ReelSeq]=1));

 

[marlan]

Please note the spaces in what appears to be a table name alias:

UPDATE RollInfo 

INNER JOIN RollInfo 

AS RollInf[COLOR="red"]o_[/COLOR]1 

ON (RollInfo.PalletNo = RollInfo_1.PalletNo) AND (RollInfo.PackListNo = RollInf[COLOR="Red"]o _[/COLOR]1.PackListNo) 

SET RollInfo.PackageNo = [RollInf[COLOR="red"]o _[/COLOR]1].[GBN_Fin_Roll_ID]

WHERE (([RollInf[COLOR="red"]o _[/COLOR]1].[ReelSeq]=1));

See if fixing alias to RollInfo_1 makes a difference.

 

[mbryan]

Marlan

That did it, thanks a bunch!!!

Nothing like a fresh set of detailed eyes to look at something.

Thanks,

Mike