Reputation: 33
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
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