How to select data from multiple tables

      SELECT column-1 [, column-2] ... 
      FROM table-1 {
        INNER | LEFT OUTER | RIGHT OUTER
      } JOIN table-2 ON table-1.column-1 = table-2.column-2 
      [WHERE selection-criteria] 
      [ORDER BY column-1 [ASC|DESC] [, column-2 [ASC|DESC]] ...];
      

      SELECT categoryName, productName, listPrice 
      FROM categories 
      INNER JOIN products 
      ON categories.categoryID = products.categoryID 
      WHERE listPrice > 800 
      ORDER BY listPrice ASC;
      

Description

• To return a result set that contains data from two tables, you join the tables. To do that, you can use a JOIN clause.
• Most of the time, you’ll want to code an inner join so rows are only included when the key of a row in the first table is equal to (matches) the key of a row in the second table.
• An outer join returns rows from one table in the join even if the other table doesn’t contain a matching row. This is useful if you need to see all the records in a table whether or not there is a match in the other table.
• In a left outer join, the data for all of the rows in the first table (the one on the left) are included in the table, but only the data for matching rows in the second table are included. In a right outer join, the reverse is true.