To join the columns of each row from two or more queries based on the specified condition. This is an inner join where joined results contain only those rows that have matches from all the queries involved in the join.

To join the columns of each row from two or more queries based on matches for the column(s) specified. Each query result must contain columns that match this list.

To join the columns of each row from two or more queries based on equivalent values in the columns in query results with matching names. Columns with matching names must contain data of the same type.

Creates a Cartesian product matching each row from one query with every row from one or more additional queries and including all the columns.

Merges the results of two of more queries including every row. Each query must contain the same columns with the same datatype. The distinct keyword is optional as duplicate rows are removed from the result by default.

Merges the results of two of more queries including every row (duplicates are not removed). Each query must contain the same columns with the same datatype.

Includes each row from the results of the first query that has a matching row in the results of the second query. The distinct keyword is optional as the default behavior is to remove duplicate rows from the first query results.

Includes all rows, including duplicates, from the results of the first query that have a matching row in the results for the second query.

Includes each row from the first query that does not match any row in the second query. The distinct keyword is optional as the default behavior is to remove duplicate rows from the first query results.

Includes all rows, including duplicates, that do not match any row in the second query.