When combining rows from multiple tables in one query, you need to use the JOIN command. While there are a number of type of joins databases offers, the most common are the INNER JOIN and the OUTER JOIN (LEFT OUTER JOIN and RIGHT OUTER JOIN).