Joins are used to connect the two or more table on the basis of some key in table.
Following are the main type of table joins
Self Join: A joins between two or more table, in which they join to same table (means only one table involved in actual).
Left join: A join between two or more table, in which in output left's table all reocord & right table only those which is matched.
Right join: A join between two or more table, in which in output right's table all reocord & left table only those which is matched.
Inner join: A join between two or more table, in which in output only those record which is matched.
Outer join: A join between two or more table, in which in output they have all the record.
Following are the main type of table joins
Self Join: A joins between two or more table, in which they join to same table (means only one table involved in actual).
Left join: A join between two or more table, in which in output left's table all reocord & right table only those which is matched.
Right join: A join between two or more table, in which in output right's table all reocord & left table only those which is matched.
Inner join: A join between two or more table, in which in output only those record which is matched.
Outer join: A join between two or more table, in which in output they have all the record.
No comments:
Post a Comment