-
returns all the matching rows from 2 tables.
-
returns only the rows from the first table, which have non-matching values with the second table in the field on which the 2 tables are joined.
-
returns all rows from 2 tables.
-
returns all rows that have matching value in the field on which the 2 tables are joined.