Question

Another method of combining two or more tables by appending rows of data from one table to another (focuses on adding more rows rather than columns) is known as _______

Answer 1

A method called union in SQL databases combines tables by appending rows from one table to another. It focuses on increasing row count rather than adding more columns.

Step-by-step explanation:

The method of combining two or more tables by appending rows of data from one table to another is known as union. This operation is used in the context of SQL in databases and is particularly useful when you want to combine datasets with similar structures to add more rows of data. The primary focus of a union operation is to increase the number of rows in a result set, as opposed to joining tables which usually adds more columns by combining related data across tables.