A Complete Tuotorial of JOIN

Share this post!

Vote this!

The Very Basics of JOIN

Sometimes you need information that has been separated out into different tables. For instance, imagine you are a programmer on an in-house eCommerce site for a company that sells computer parts around the world. The Sales Manager walks down the hall one day and says she wants a detail listing of customer types and order dates. Our customer types are in the CUSTOMERS table, and the order dates are in the ORDERS table, so what she wants is this:
A SELECT statement to pull these columns would look like this:

SELECT customers.customer,customers.custtype,orders.date
  FROM customers 
  JOIN orders     ON customer.customer = order.customer

More... 

RECOMMENDED READING 

PART - 2 The Many Forms of JOIN