I have 2 tables in the same database.
I want to merge them based on the common id
column. Because the tables are too huge I am not sure if there are duplicates.
How is it possible to merge these two tables into one based on the id
and be sure that there are no duplicates?
SELECT *
FROM table1,table2
JOIN
GROUP BY id
I am not sure What exactly do you want but anyway, this is your code
i just edit your query