Arumugam Rajamani
Arumugam Rajamani

Reputation: 33

How to update multiple rows based on single column using two different tables

I Have a two tables first table js_resume column is empty but second table js_resume column have a data

I want to compare based on js_email when js_resume is empty need to update data from second table .

FIRST TABLE

+--------------------------------+-----------+
| js_email                       | js_resume |
+--------------------------------+-----------+
| [email protected]            |           |
| [email protected]       |           |
| [email protected]       |           |
| [email protected]         |           |
| [email protected]                 |           |
| [email protected]             |           |
| [email protected] |           |
| [email protected]            |           |
| [email protected]        |           |
| [email protected]           |           |
+--------------------------------+-----------+


Second table

+----------------------------+-------------------+
| js_email                   | js_resume         |
+----------------------------+-------------------+
| [email protected]        | resume_59053.docx |
| [email protected]   | resume_59051.docx |
| [email protected]      | resume_59049.doc  |
| [email protected]   | resume_59029.doc  |
| [email protected]      | resume_59047.doc  |
| [email protected]             | resume_59046.doc  |
| [email protected]        | resume_59045.docx |
| [email protected]           | resume_59044.docx |
| [email protected]       | resume_59043.doc  |
| [email protected]       | resume_59042.docx |
+----------------------------+-------------------+

Expected Output

+--------------------------------+----------------------------+
| js_email                       | js_resume                  |
+--------------------------------+----------------------------+
| [email protected]            |  resume_59053.docx         |
| [email protected]       |  resume_59051.docx         |
| [email protected]       |                            |
| [email protected]         |                            |
| [email protected]                 |  resume_59046.doc          |
| [email protected]             |                            |
| [email protected] |                            |
| [email protected]            |                            |
| [email protected]        |                            |
| [email protected]           | resume_59042.docx          |
+--------------------------------+----------------------------+

Upvotes: 0

Views: 65

Answers (1)

Nafis Islam
Nafis Islam

Reputation: 1509

Something like this?

UPDATE FIRSTTABLE a
    JOIN Secondtable b ON a.js_email = b.js_email
SET a.js_resume = b.js_resume

Upvotes: 1

Related Questions