What is a join and explain different types of joins

Ads

 
 

Share on Google+Share on Google+

hemant kumar
What is a join and explain different types of joins
1 Answer(s)      6 years and 10 months ago
Posted in : SQL

What is a join and explain different types of joins?

Ads
View Answers

November 20, 2010 at 12:01 PM


Hi,

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.

Thanks,


Ads









Related Tutorials/Questions & Answers:
What is a join and explain different types of joins
What is a join and explain different types of joins  What is a join and explain different types of joins?   Hi, Joins are used in queries to explain how different tables are related. Joins also let you select data from
What are constructors ? explain different types of constructor with example
What are constructors ? explain different types of constructor with example  Hi, What are constructors ? explain different types of constructor... To know more related to What are constructors with examples
Advertisements
What is outer join?Explain with examples.
What is outer join?Explain with examples.  What is outer join?Explain with examples
What are the different types of AutoProxying?
What are the different types of AutoProxying?  Hi, What are the different types of AutoProxying? Thanks
WHAT ARE THE DIFFERENT TYPES OF ERRORS IN PHP?
WHAT ARE THE DIFFERENT TYPES OF ERRORS IN PHP?  WHAT ARE THE DIFFERENT TYPES OF ERRORS IN PHP
What are the different types of property and class mappings?
What are the different types of property and class mappings?  Hi, What are the different types of property and class mappings? thanks
Mysql Join Types
Mysql Join Types       The Tutorial help you to understand an example on different types of join. To grasp the different type of join, we create a table 'roseindia
What are the different types of interfaces in java? - Java Interview Questions
What are the different types of interfaces in java?  Hi, Is it correct question.I faced this in one interview. If yes can u tell me please. thanks chandu
What is a "join"?
What is a "join"?  What is a "join"?   Hi, Here is the answer, The JOIN keyword is used in an SQL statement to query data from two.... Tables in a database are often related to each other with keys.A join is used
Explain types of java programs
Explain types of java programs  Explain types of java programs   Types of Java Programs: Standalone Applications Web Applications Enterprise Applications Console Application Web services
JOINS
JOINS  hii,, What is joins?   hii, join provides relationship between two or more table. If we want to access data from more then one table at a time we use join
Hibernate Joins
In this section, you will learn about types of joins in Hibernate
different types of storage devices of a computer
different types of storage devices of a computer  What are the different types of storage devices of a computer?   Magnetic disks, Tapes and DVDs are few examples of storage devices of a computer
What is Self Join?
What is Self Join?  What is Self Join?   Hi, A Self Join is a type of sql join which is used to join a table to itself, particularly when... to ensure that the join statement defines an alias for both copies of the table
Different types of web hosting services
. I was browsing their websites but still could not understood the different types of web hosting services. Can anyone explain me different types of web hosting...Different types of web hosting services  Hi, There are many
How to Explain different way of using thread?
How to Explain different way of using thread?  Hi, How to explain how to using different thread in Java program........   Hi, There are different types Thread in Java program. Here is the explain how to using thread
What are the types of Advice?
What are the types of Advice?   Hi, What are the types of Advice? Thanks
size of different basic data types
size of different basic data types   Write a simple program to find the size of different basic data types in java
Object with different data types
Object with different data types  Hello, I need to build a "patient" object that can contain String "name", String "ID", double "weight" and Date "birthDate". Then that object is referenced to the linked list. I know how to use
what is the meaning of this or explain this
what is the meaning of this or explain this  List<Object[]> list=query.list();   Hi Friend, It will return the query values in the form of list. For more information, visit the following link: Hibernate
What are the Collection types in Hibernate ?
What are the Collection types in Hibernate ?  hi, What are the Collection types in Hibernate ? Thanks
What is Headers and Mime Types ?
What is Headers and Mime Types ?  Headers and Mime Types   ... outputting a different content type in spite of current file extension ends in PHP. Here in this post I have collected a list of popular HeaderÔ??s content types
What is a vector in Java? Explain with example.
What is a vector in Java? Explain with example.  What is a vector in Java? Explain with example.   Hi, The Vector is a collect of Object... when required. There are 2 types of Vector i.e. synchronized and Vector contains
Java Cross Join MySQL
Java Cross Join MySQL In this section we will read about how the two tables can be joined using cross join in MySQL. Here we will see cross joining using a simple example. Cross Join in SQL joins two tables. These two tables are joined
How to Explain different way of using thread?
How to Explain different way of using thread?  Hi, How to explain how to using different thread in Java program
What are the types of triggers?
What are the types of triggers?  What are the types of triggers?   Hi, There are 12 types of triggers in PL/SQL that consist of combinations of the BEFORE, AFTER, ROW, TABLE, INSERT, UPDATE, DELETE and ALL key words
WHAT TYPES OF IMAGES THAT PHP SUPPORTS?
WHAT TYPES OF IMAGES THAT PHP SUPPORTS?  WHAT TYPES OF IMAGES THAT PHP SUPPORTS
What are the types of inheritance models in Hibernate?
What are the types of inheritance models in Hibernate?  Hi, What are the types of inheritance models in Hibernate? thanks
Know the Different Types of E-Commerce
Know the Different Types of E-Commerce There are different types of e-commerce and we need to know what e-commerce is and how different it is from e... can send across different kinds of files and information which can
Hibernate Outer Join
In this section, you will learn about types of outer joins in Hibernate
What are different normalization forms?
What are different normalization forms?  What are different normalization forms?   Hi, 1NF: Eliminate Repeating Groups- Make a separate table for each set of related attributes, and give each table a primary key. Each