I have a table `REVERSE` with columns as 

```
ID ORG_ID FULL_ID DATE_REV
-- ------ ------- --------
X1 11%    NULL
X2 22%    NULL
X3 33%    NULL
X4 44%    NULL
X5 55%    NULL

```

I have another table `MASTER` with columns as

```
FULL_ORG DATE 
-------- --------
11ABC    20190101
22DEF    20190101
33GHI    20190101
44XYZ    20190101
55MNO    20190101

```

How can i find the FULL\_ORG and corresponding DATE value from `MASTER` using the ORG\_ID from `REVERSE`, and update in the FULL\_ID field and DATE\_REV field correspondingly.

Please help.. 

The result should be as below.

```
TXN ORG_TXN FULL_ORG DATE
--- ------- -------- --------
  1 11%     11ABC    20190101
  2 22%     22DEF    20190101
  3 33%     33GHI    20190101
  4 44%     44XYZ    20190101
  5 55%     55MNO    20190101

```