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

What is action query?

947

---

Write a query to fetch duplicate records from a table using mysql?

989

---

Why use mysql procedures?

1027

---

What is mysql database extension?

1088

---

What is the difference between now() and current_date()?

1022

---

How do I run mysql on a mac?

1012

---

What is use of mysql?

981

---

What is a string in mysql?

960

---

What is difference between schema and table?

965

---

What is definer in mysql trigger?

976

---

Where is the mysql data directory?

991

---

How to update database permissions/privilages.

1032

---

What is back end and front end?

953

---

What is a tinyint?

996

---

Why is mysql popular?

936

---