Unanswered: Compare two tables and save it to a 3rd table
I have to compare two tables and save the matching result to a third table.
I can't seem to save anything even thou i have the matching result displayed on the screen.
Here is what I did :
SELECT * FROM table1, table2
-> WHERE table1.column2 = table2.column2
-> ORDER BY column2;
I tried JOIN / NATURAL JOIN / INJOIN ..
Maybe I had an improper synthax .. neway nothing worked out so far I just ended up with a JOINT pain ..
Things you should know:
- Table 1, 2 and 3 have the exact same format.
- Column2 is defined as an integer
- Our DB exceed 3Gb..
- Sorry if this is baby step .. im started mysql 2 weeks ago
- Thanks Thanks Thanks