Watch this video on YouTube
In an ANSI-SQL compliant database, you have two tables with matching columns that require swift combination into a single table, eliminating duplicate rows from the result. What's the optimal approach?