What is a join and explain different types of joins.
Page 1 of 1
What is a join and explain different types of joins.
by Micheal Tue Jan 12, 2010 8:43 pm
Joins are used in queries to explain how different tables are related. Joins also let you select data from a table
depending upon data from another table.
Types of joins: INNER JOINs, OUTER JOINs, CROSS JOINs. OUTER JOINs are further classified as LEFT OUTER
JOINS, RIGHT OUTER JOINS and FULL OUTER JOINS.
For more information see pages from books online titled: "Join Fundamentals" and "Using Joins".
depending upon data from another table.
Types of joins: INNER JOINs, OUTER JOINs, CROSS JOINs. OUTER JOINs are further classified as LEFT OUTER
JOINS, RIGHT OUTER JOINS and FULL OUTER JOINS.
For more information see pages from books online titled: "Join Fundamentals" and "Using Joins".
Micheal- Admin
- Posts : 243
Join date : 2010-01-10 -
Similar topics» What is a self join? Explain it with an example.
» What are constraints? Explain different types of constraints.
» Explain different isolation levels
» Explain the relationship among Database, Tablespace and Data file.?
» What Are the Types PL/SQL Code Blocks?
» What are constraints? Explain different types of constraints.
» Explain different isolation levels
» Explain the relationship among Database, Tablespace and Data file.?
» What Are the Types PL/SQL Code Blocks?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
» Accessing tables of other users in SQL
» Grouping commands in SQL
» Operations on Result Sets in SQL
» Subqueries in SQL
» Joining Relations in SQL
» Delete comand in SQL
» Update command in SQL
» Insert command in SQL