| Term | Definition |
|---|
| SELECT column_name(s) FROM table_name1 INNER JOIN table_name2 ON table_name1.column_name=table_name2.column_name | return rows when there is at least one match in both tables |
| SELECT column_name(s)FROM table_name1 RIGHT JOIN table_name2 ON table_name1.column_name=table_name2.column_name | return all rows from the right table (table_name2), even if there are no matches in the left table (table_name1). |
| SELECT column_name(s) FROM table_name1 FULL JOIN table_name2 ON table_name1.column_name=table_name2.column_name | returns rows when there is a match in one of the tables. |
| SELECT column_name(s) FROM table_name1 LEFT JOIN table_name2 ON table_name1.column_name=table_name2.column_name | returns all rows from the left table (table_name1), even if there are no matches in the right table (table_name2) |
Combine with other sets
Share on Facebook
Share on MySpace