having trouble with joins

Anthony97

I can't get this code to run on SQL server without the following error

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'JOIN'.

UPDATE [tblAcsChargeAmts]
JOIN [T Accessorials_Estimated]
ON [tblAcsChargeAmts].[Shipment Id] = [T Accessorials_Estimated].[Shipment Id]
AND [tblAcsChargeAmts].[Load Id] = [T Accessorials_Estimated].[Load Id]
AND [tblAcsChargeAmts].[Acs Code] = [T Accessorials_Estimated].[Acs Code])
SET [tblAcsChargeAmts].[Est AP Amt] = [T Accessorials_Estimated].[AP Est Acs Amt],
[tblAcsChargeAmts].[Est AR Amt] = [T Accessorials_Estimated].[AR Est Acs Amt]
WHERE [tblAcsChargeAmts].[Est AP Amt] = 0
OR [tblAcsChargeAmts].[Est AR Amt] = 0;

Delerna

Here is the example from SQL servers help documentation

Expand|Select|Wrap|Line Numbers

 
UPDATE titleauthor

   SET title_id = titles.title_id

   FROM titles INNER JOIN titleauthor 

      ON titles.title_id = titleauthor.title_id 

      INNER JOIN authors

      ON titleauthor.au_id = authors.au_id

   WHERE titles.title = 'Net Etiquette'

      AND au_lname = 'Locksley'

you need to model your update query like that.

Just a hint....

There is a lot of help available in MSSQL's help (with examples) that answers questions like this. You access that help from "query analyser"....not from "Enterprise manager".
PS Im talking from the perspective of MSSQL Server 2000 here. It's probably different in later versions

having trouble with joins

re: having trouble with joins

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about