Attempting to do an update in SQL Server 2005 with query originally created in Access

[rob41]

This is the code and I'm getting a syntax error at the From statement:

Msg 156, Level 15, State 1, Line 33
Incorrect syntax near the keyword 'FROM'.

Any suggestions on what've done wrong?

UPDATE
[tblShipments]
SET
[tblShipments].[FC] = [T PC Codes].[FC],
[tblShipments].[XPD] = [T PC Codes].[XPD],
[tblShipments].[SDEL] = [T PC Codes].[SDEL],
[tblShipments].[CDEL] = [T PC Codes].[CDEL],
[tblShipments].[CDRS] = [T PC Codes].[CDRS],
[tblShipments].[MNMC] = [T PC Codes].[MNMC],
[tblShipments].[MCAC] = [T PC Codes].[MCAC],
[tblShipments].[CFAL] = [T PC Codes].[CFAL],
[tblShipments].[WTHR] = [T PC Codes].[WTHR],
[tblShipments].[SCBK] = [T PC Codes].[SCBK],
[tblShipments].[CCBK] = [T PC Codes].[CCBK],
[tblShipments].[UPSA] = [T PC Codes].[UPSA],
[tblShipments].[RC] = [T PC Codes].[RC],
[tblShipments].[Item Category] = [T PC Codes].[Item Category],
[tblShipments].[DN Flag] = [T PC Codes].[DN Flag],
[tblShipments].[MC Flag] = [T PC Codes].[MC Flag],
[tblShipments].[OP Flag] = [T PC Codes].[OP Flag],
[tblShipments].[PD Flag] = [T PC Codes].[PD Flag],
[tblShipments].[SU Flag] = [T PC Codes].[SU Flag],
[tblShipments].[QU Flag] = [T PC Codes].[QU Flag],
[tblShipments].[IN Flag] = [T PC Codes].[IN Flag],
[tblShipments].[SE Flag] = [T PC Codes].[SE Flag],
[tblShipments].[TN Flag] = [T PC Codes].[TN Flag],
[tblShipments].[CUDC Flag] = [T PC Codes].[CUDC],
[tblShipments].[FP Flag] = [T PC Codes].[LCFP],
[tblShipments].[TT Flag] = [T PC Codes].[TT Flag],
[tblShipments].[PU Flag] = [T PC Codes].[PU Flag],
[tblShipments].[EG Flag] = [T PC Codes].[EG Flag],
[tblShipments].[OL Flag] = [T PC Codes].[OL Flag];
FROM
[tblShipments]
LEFT OUTER JOIN [T PC Codes]
ON ([tblShipments].[Shipment Id] = [T PC Codes].[Shipment Id])
AND (tblShipments.[Load Id] = [T PC Codes].[Load Id])

[Delerna]

in this part
[code=sql]
LEFT OUTER JOIN [tblShipments].[OL Flag] = [T PC Codes].[OL Flag];
FROM
[/code]
you need to remove the semi colon

[code=sql]
LEFT OUTER JOIN [tblShipments].[OL Flag] = [T PC Codes].[OL Flag]
FROM
[/code]