Thanks to all.
I for got to add dbo.WipJobAllMat in the FROM
CREATE PROC sp_UdateWipBinLocations
AS
Update dbo.WipJobAllMat
Set dbo.WipJobAllMat.Bin = dbo.InvWarehouse.DefaultBin
FROM dbo.InvWarehouse, dbo.WipJobAllMat
INNER JOIN dbo.WipMaster ON dbo.WipJobAllMat.Job = dbo.WipMaster.Job
Where dbo.InvWarehouse.StockCode = dbo.WipJobAllMat.StockCode
and dbo.WipJobAllMat.Job...