A Join is used to combine row from two or more table .based on min one common column. there is various type of join.
The syntax of an inner join:-
[ Select tablename.columnname(s) from table1 Inner join table2 on table1.columnname =table2.columnname ]
Ex: – we have two table first table names is a category and second is subcategory and the common row is category so let see how to use inner join in both tables.
The syntax of a left join:-
[ Select tablename.columnname(s) from table1 Left join table2 on table1.columnname =table2.columnname ]
Ex:- we have two table first table names is category and second is subcategory and the common row is category id so let see how to use Left join in both tables.
The syntax of right join:-
[ Select tablename.columnname(s) from table1 Right join table2 on table1.columnname =table2.columnname ]
Ex: – we have two table first table names is a category and second is subcategory and the common row is category so let see how to use Right join in both tables.
The syntax of Full outer join:-
[ Select tablename.columnname(s) from table1 Full Outer join table2 on table1.columnname =table2.columnname ]
The syntax of self-join:-
[ Select tablename.columnname(s) from table1 Self join table2 on table1.columnname =table2.columnname ]
We have three table first table category second is subcategory and third is a product
The syntax of three table join:-
[ Select tablename.columnname(s) from table1 Inner join table2 on table1.columnname =table2.columnname Inner join table 3 on table2.columnname = table 3.column name ]
Ex:-
It’s difficult to find knowledgeable people in this particular topic, but you sound like you know what you’re talking about! Thanks
I am happy that I noticed this web blog, just the right info that I was looking for! .
“This website really has all of the info I wanted about this subject and didn’t know who to ask.”
I’ve been surfing online more than 2 hours today, yet I never found any interesting article like yours.
It’s pretty worth enough for me. In my opinion, if all webmasters and bloggers made
good content as you did, the net will be much more useful than ever before.
About the author