MySQL SQL - How To Join Two Tables in a Single Query
Interview Question Database For Software Developers
|
|
| How To Join Two Tables in a Single Query | | How To Join Two Tables in a Single Query? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries | | By: FYIcenter.com | Two tables can be joined together in a query in 4 ways:
- Inner Join: Returns only rows from both tables that satisfy the join condition.
- Left Outer Join: Returns rows from both tables that satisfy the join condition,
and the rest of rows from the first (left) table.
- Right Outer Join: Returns rows from both tables that satisfy the join condition,
and the rest of rows from the second (right) table.
- Full Outer Join: Returns rows from both tables that satisfy the join condition,
the rest of rows from the first (left) table, and the rest of rows from the second (right) table.
| | ID: 1148 | Rank: 1065 | Votes: 0 | Views: 37 | Submitted: 20070511 |
Copyright © 2009 FYIcenter.com
All rights in the contents of this Website are reserved by the individual author.
No part of the contents may be reproduced in any form without author's permission.
|
|
|
Atom feed
List view