|
Combine two SQL tables
Lets say I have a table in a database that runs the SQL language, I also have data on another table that I would like to combine with the exiting table. There are similar columns in the new table to that of the existing one and I would like for the database to merge the data in the two tables without creating duplicates. (For instance merging the data in a row instead of appending it whenever it detects an ID number in that row, instead of placing a new row altogether). What command would I use to go about doing this.
|
