1

Topic: Update request

All kind time of days.
Faced such problem.
There are 2 tables
Payments
Date Account Org_id Jek
5/2/2018 123456 107615
02.05.2018 654321 107615
03.05.2018 987654 107615
Pl_account
Account Jek Org_id
123456 1572 107615
654321 130 107615
543132 6598 107241
It is necessary to make Update tables Payments that field Jek was filled with values from table Pl_account by such criteria Date 5/2/2018 and Org_id = 107615
In advance all I thank for helps

2

Re: Update request

Yuriy_KUM;
Payments
| Date | Account | Org_id | Jek |
+----------+--------+-------+-----+
|5/2/2018 | 123456 |107615 | |
|5/2/2018 | 654321 |107615 | |
|5/3/2018 | 987654 |107615 | |
Pl_account
Account | Jek |Org_id
--------+-----+------
123456 |1572 |107615
654321 |130 |107615
543132 |6598 |107241

3

Re: Update request

Only yesterday there was something similar
Only a title of fields to change.