update query is not working

[haresh]

update Query - UPDATE BNPARB_EOD_Sum LEFT JOIN Trades ON (sgn(BNPARB_EOD_Sum.Position)=sgn(Trades.TradePosition))
AND (BNPARB_EOD_Sum.ChildAccount=Trades.Account) AND (BNPARB_EOD_Sum.CTCLID=Trades.NNFComplianceId)
AND (Cdate(BNPARB_EOD_Sum.[Trade Date])=Cdate(Trades.TradeDate))
AND (cdate(BNPARB_EOD_Sum.Maturity)=cdate(Trades.ExpiryDate)) AND (BNPARB_EOD_Sum.Underlying=Trades.MDSCode)
SET Trades.Portfolio = BNPARB_EOD_Sum.Portfolio, Trades.Desk = BNPARB_EOD_Sum.Desk

I have 2 table 1. singal line (50 Record) table and 2 Summary of table (2 Record)
i need to update only those each Position (2 record) match with table1 (6 recored match ) need to update but above Query is updating all recored (50)

two table attached in text file

 

[jdraw]

In my view, you are telling the query to Update table UPDATE BNPARB_EOD_Sum,
but you are syntactically setting a field in another table
SET Trades.Portfolio = BNPARB_EOD_Sum.Portfolio

Why exactly are you using LEFT JOIN?

Update query example http://www.w3schools.com/sql/sql_update.asp
Left join examples http://www.w3schools.com/sql/sql_join_left.asp

 

[haresh]

Hi jdraw,

Thanks for reply on my query

This to info you that, while update in access query present in this manner only.

Why exactly are you using LEFT JOIN?- I want to match all case and then need to update as others record is also available in the table , if i am not using then it wiil update all table ....

Kindly suggest if you have any other alternative

Thanks once again

Haresh Hemani