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

How to decrement dates by 1 in mysql?

953

---

Which storage engine is best in mysql?

895

---

What are the disadvantages of stored procedures?

922

---

What language is mysql written in?

932

---

Can you tell a way to know the number of days between the two given dates in php?

1021

---

How to enter binary numbers in sql statements?

936

---

explain GROUPBY & HAVING clause with examples.

2233

---

What are the functions used to encrypt and decrypt the data present in mysql?

1022

---

How to escape special characters in sql statements?

922

---

Explain the difference between primary key and candidate key in mysql?

914

---

What is join in mysql? What are the different types of join?

894

---

Is mysql a server or database?

851

---

Explain the difference between delete and truncate.

941

---

What storage engines are used in MySQL?

987

---

What is heap table?

974

---