Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

The RIGHT JOIN: Matching records plus orphans from the right When you execute a query using the RIGHT JOIN syntax, SQL does two things: It returns all of the records from both tables that contain ...

A join combines two or more tables side by side. If you do not specify how to join the tables, you get a Cartesian product. This means that SQL combines each row from the first table with every row ...

The LEFTTAB and RIGHTTAB tables are used to illustrate this type of join: The following example joins the LEFTTAB and RIGHTTAB tables to get the Cartesian product of the two tables. The Cartesian ...