update table value with value from another table

[יריב החביב]

Hello,

i have to update [paymenorder] from table Sheet1

to Drishot.payment_condition.

i wrote code (update query)

UPDATE Drishot LEFT JOIN Sheet1 ON Drishot.Drisha_Code = Sheet1.filenum SET
Drishot.payment_condition = Sheet1![paymenorder];


it's not update, why ?

thank you

 

[יריב החביב]

it's working.

Sorry

 

[waldemar-barbie]

Hello,

i have to update [paymenorder] from table Sheet1

to Drishot.payment_condition.

i wrote code (update query)

UPDATE Drishot LEFT JOIN Sheet1 ON Drishot.Drisha_Code = Sheet1.filenum
SET
Drishot.payment_condition = Sheet1![paymenorder];


it's not update, why ?

thank you