I have two different tables and i decided to merge them into one table...
the birth table has
id, name, country, birthday_date, description, link
the death table has
id, name, country, death_date, description, link
and i want to merge them into a single table with the structure
id, name, country, bdate, ddate, description, link.
The link from each table has a unique value so i have to merge the tables using the link. I tried many queries but resulted in wrong results.
Both the birth and death table can have same names and some names may have either only birth or death date.
How can i merge them and updating a null date for a column that has no value on either tables?