SQL INNER JOIN
SQL Using Inner JOIN.
- INNER JOIN is the same as JOIN.
Return rows when there is at least one match in both of two tables.
Pictorial representation :
A skeleton syntax version of JOIN using the ON keyword is this:
SELECT select_list FROM table_1 [INNER] JOIN table_2 ON [table_1.]column join_operator [table_2.]column [WHERE search_conditions ] [ORDER BY column1, column2, ... ]Example using JOIN between the tables with ON:SQL server, MySQL, Oracle, PostgreSQL :
Select First_name "First name", Last_name "Last name", email, Telephone_type "Phone type", Telephone_number as "Phone number" from customers c INNER JOIN telephones t /* or: JOIN telephones t*/ ON c.customer_id=t.customer_id where t.Telephone_type<>'Unknown' order by Last_name;The result should be:
First name Last name Phone type Phone number Judith Bowman J.Bowman@imb.com Cell (371) 153-54 Judith Bowman J.Bowman@imb.com Work (371) 143-54 Ricard Nixon Ricard.Nixon@hotmail.com Work (978) 667-94 Ricard Nixon Ricard.Nixon@hotmail.com Home (978) 667-94 Robert Redford R.Redford@google.com Home (679) 234-94
© 2010 by Finnesand Data. All rights reserved.
This site aims to provide FREE programming training and technics.
Finnesand Data as site owner gives no warranty for the
correctness in the pages or source codes.
The risk of using this web-site pages or any program
codes from this website is entirely at the individual user.