joins in Database

Author Topic: joins in Database  (Read 4646 times)

Offline SeoDezinTopic starter

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 3
  • Posts: 123
  • Karma: 1
  • Gender: Male
joins in Database
« on: 05-09-2011, 03:49:00 »
How many types of joins are in database? What are its effects? I need detail help in this sense.

Offline Vinil

  • Trade Count: (0)
  • Sr. Member
  • ****
  • Thank You 90
  • Posts: 301
  • Karma: 13
  • Gender: Male
  • I can and I Will
    • Boaters Directory
Re: joins in Database
« Reply #1 on: 08-16-2011, 04:01:09 »
Following are types of SQL joins:-
Join-returns both the tables if their is atleast one match in database of two tabels
Left Join-returns all the left table data even if their is no match with right table
Right Join-returns all the  right table rows only ,even when their is no match in left table rows
Full Join-returns a row when their is match in one table

Offline sourabhsharma.obizm

  • Trade Count: (0)
  • Newbie
  • *
  • Thank You 0
  • Posts: 1
  • Karma: 0
Re: joins in Database
« Reply #2 on: 07-19-2012, 14:17:12 »
There are different types of joins like inner join, outer join, self join, cross join, natural join, equi join, non-equi join.

Offline navkesh

  • Trade Count: (0)
  • Semi-Newbie
  • *
  • Thank You 0
  • Posts: 29
  • Karma: 2
    • Copenhagen Tours
Re: joins in Database
« Reply #3 on: 09-15-2012, 13:15:34 »
A join is a query that combines rows from two or more tables, views, or materialized views.

Joins in Oracle:
  • Equi Join: An equijoin is a join with a join condition containing an equality operator. An equijoin combines rows that have equivalent values for the specified columns.
  • Self Join: A self join is a join of a table to itself. This table appears twice in the FROM clause and is followed by table aliases that qualify column names in the join condition.
  • Cartesian Products: If two tables in a join query have no join condition, then Oracle Database returns their Cartesian product.
  • Inner Join: An inner join (sometimes called a simple join) is a join of two or more tables that returns only those rows that satisfy the join condition.
  • Outer Join: An outer join extends the result of a simple join. An outer join returns all rows that satisfy the join condition and also returns some or all of those rows from one table for which no rows from the other satisfy the join condition.
  • Anti Join: An antijoin returns rows from the left side of the predicate for which there are no corresponding rows on the right side of the predicate. It returns rows that fail to match (NOT IN) the subquery on the right side.
  • Semi Join: A semijoin returns rows that match an EXISTS subquery without duplicating rows from the left side of the predicate when multiple rows on the right side satisfy the criteria of the subquery.

Joins in SQL Server:
  • Inner Join: Return rows when there is at least one match in both tables.
  • Left Join: Return all rows from the left table, even if there are no matches in the right table.
  • Right Join: Return all rows from the right table, even if there are no matches in the left table.
  • Full Join: Return rows when there is a match in one of the tables.
Joins in PHP:
  • CROSS JOIN: This type of join is the simplest join. The cross join result in cartesian product of all the records from two tables.
  • INNER JOIN OR EQUI JOIN: This is the type of join where tables are combined based on a common column.
  • OUTER JOIN: Join is used to combine all rows of one table with  matching rows from the other table and also show unmatchable records from other table. It is used whenever multiple tables must be accessed through a SQL SELECT statement

Offline tomfam

  • Trade Count: (0)
  • Newbie
  • *
  • Thank You 0
  • Posts: 7
  • Karma: 0
    • Mobile application development companies South Carolina
Re: joins in Database
« Reply #4 on: 01-04-2016, 00:30:45 »
 Join is a relationship between two table or more tables.There are mainly 4 types of Join-
1- Self Join
2- Inner Join
3-Outer join
4-Cross Join
newbielink: [nonactive]

Offline qx_1789

  • Trade Count: (0)
  • Jr. Member
  • **
  • Thank You 0
  • Posts: 72
  • Karma: 0
  • Working in QualityPoint Technologies
Re: joins in Database
« Reply #5 on: 03-11-2016, 23:51:29 »
SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations. Watch this video and learn about different type of joins.


Related Topics

  Subject / Started by Replies Last post
0 Replies
Last post 11-03-2011, 04:41:14
by manvbf
0 Replies
Last post 12-28-2012, 00:28:03
by Die Hard
0 Replies
Last post 05-22-2013, 10:53:57
by nadim123
1 Replies
Last post 06-23-2015, 00:53:38
by Talukdar
0 Replies
Last post 12-22-2015, 00:15:35
by chinmay.sahoo