what is JOIN? Give example & types of join?
Answer Posted / antergen suvi danis
Join Syntax:
table_references:
table_reference [, table_reference] ...
table_reference:
table_factor
| join_table
table_factor:
tbl_name [[AS] alias] [index_hint)]
| table_subquery [AS] alias
| ( table_references )
| { OJ table_reference LEFT OUTER JOIN table_reference
ON conditional_expr }
join_table:
table_reference [INNER | CROSS] JOIN table_factor
[join_condition]
| table_reference STRAIGHT_JOIN table_factor
| table_reference STRAIGHT_JOIN table_factor ON
conditional_expr
| table_reference {LEFT|RIGHT} [OUTER] JOIN table_reference
join_condition
| table_reference NATURAL [{LEFT|RIGHT} [OUTER]] JOIN
table_factor
join_condition:
ON conditional_expr
| USING (column_list)
index_hint:
USE {INDEX|KEY} [FOR JOIN] (index_list)
| IGNORE {INDEX|KEY} [FOR JOIN] (index_list)
| FORCE {INDEX|KEY} [FOR JOIN] (index_list)
index_list:
index_name [, index_name] ...
Types of join are,
* Inner Join
* Left Join or Left Outer Join
* Right Join or Right Outer Join
* Equi join
* Non Equi Join
* Natural Join
* Straight Join
Is This Answer Correct ? | 16 Yes | 15 No |
Post New Answer View All Answers
Why does mysql have so many connections?
What is mysql database server?
What is tee command in mysql?
How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
How can I remotely connect to mysql database?
Can foreign key have duplicate values?
What is the full form of mysql?
What is blob and clob?
What is difference between mongodb and mysql?
What is horizontally scalable?
What is the role of a limit in a mysql query?
What is innodb mysql?
What does mysqli stand for?
How to start mysql server?
What is sharding in mysql?