By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,149 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

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

P: 2
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])
Aug 11 '09 #1
Share this Question
Share on Google+
1 Reply


Delerna
Expert 100+
P: 1,134
in this part
Expand|Select|Wrap|Line Numbers
  1. LEFT OUTER JOIN [tblShipments].[OL Flag] = [T PC Codes].[OL Flag];
  2. FROM 
  3.  
you need to remove the semi colon

Expand|Select|Wrap|Line Numbers
  1. LEFT OUTER JOIN [tblShipments].[OL Flag] = [T PC Codes].[OL Flag]
  2. FROM 
  3.  
Aug 12 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.