Match the following terms to the appropriate definition:
1. equi-join
2.derived table
3.natural join
4.correlated subquery
5.outer join
6.trigger
- returns all records of a designated table
- keeps redundant columns
3. utilizes values from the main query in the subquery
4. the outcome of a query embedded in the FROM clause
5. A set of SQL statements executed under specific conditions
6. does not keep redundant columns