Microsoft® Access supports right and left outer joins. Microsoft SQL Server™ supports these and other SQL-92 standard join operators.
| Join operation | Description |
|---|---|
| CROSS JOIN | Specifies the cross product of two tables be returned. This returns the same rows as if no WHERE clause was specified in an old-style join. This type of join is called a Cartesian product in Access. |
| INNER | Specifies that all inner rows be returned. Any unmatched rows are discarded. This is identical to a standard Access table join. |
| LEFT [OUTER] |
Specifies that all of the left table outer rows be returned, even if no column matches are found. This operates just like an Access left join. |
| RIGHT [OUTER] |
Specifies that all of the right table outer rows be returned, even if no column matches are found. This operates just like an Access right join. |
| FULL [OUTER] |
Specifies the row be included in the result set and its output columns that correspond to the other table be set to NULL if a row from either table does not match the selection criteria. |