You have the following two tables that contains data about the books in a library.
Both tables are incomplete, so there are books missing from the tables.
You need to combine the tables. The solution must ensure that all the data is retained.
Which type of join should you use?
To ensure that all data is retained from both tables, a full outer join should be used. A full outer join combines the results of both left and right outer joins, returning all rows from both tables with NULLs in place where the join condition is not met. This means that every book from both tables will be included in the result, regardless of whether it is missing from one of the tables.
Full outer join is the correct answer
A. Full outer join