Types of JOINs in SQL

Tags:
SQL
SQL join
What are the types of JOINs in SQL?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.
SQL Join Types:
There are different types of joins available in SQL:

INNER JOIN: returns rows when there is a match in both tables.

LEFT JOIN: returns all rows from the left table, even if there are no matches in the right table.

RIGHT JOIN: returns all rows from the right table, even if there are no matches in the left table.

FULL JOIN: returns rows when there is a match in one of the tables.

FULL OUTER JOIN: returns all the rows from the left table (Customers), and all the rows from the right table (Orders).

SELF JOIN: is used to join a table to itself as if the table were two tables, temporarily renaming at least one table in the SQL statement.

CARTESIAN JOIN: returns the Cartesian product of the sets of records from the two or more joined tables.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    You have to start from the basics. It is better to read your study books or you can link www.w3schools.com/ Wikepedia for more info.
    136,980 pointsBadges:
    report
  • ToddN2000
    A simple Google search will give you all the info you need. If there is a particular join you do not understand let us know and we will try to help.
    131,595 pointsBadges:
    report
  • carlosdl
    That is a general question, which you can easily answer yourself with a little research on the web.

    As Todd suggested, we can help you if you have specific doubts. Otherwise, you would get more complete information by searching.
    84,670 pointsBadges:
    report
  • Subhendu Sen
    I think w3schools is a better for learning of this type of basic queries.
    136,980 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: