| Цитата |
INNER JOIN specifies that the query result contain only rows from a table that match one or more rows in another table. LEFT [OUTER] JOIN specifies that the query result contains all rows from the table to the left of the JOIN keyword and only matching rows from the table to the right of the JOIN keyword. The OUTER keyword is optional; you can include it to emphasize that an outer join is created. RIGHT [OUTER] JOIN specifies that the query result contain all rows from the table to the right of the JOIN keyword and only matching rows from the table to the left of the JOIN keyword. The OUTER keyword is optional; it can be included to emphasize that an outer join is created. FULL [OUTER] JOIN specifies that the query result contain all matching and nonmatching rows from both tables. The OUTER keyword is optional; you can include it to emphasize that an outer join is created. |
