Answer Posted / shahzad

join clause is used combines records from two or more tables
in a database.it means combining fields from tables common
to each.

There are 4 common types of join
1-inner
2-outer
3-left
4-right
and special case is "" self-join ""

1-inner join
Equi-join
Natural join
Cross join
2-Outer joins
Left outer join
Right outer joins
Full outer join
other tpes are hash and merge join bu these are algorith
implementation.

How can you make a database as your current database?

1051

---

How do I install the latest mysql on ubuntu?

991

---

What are the different types of triggers in mysql?

963

---

How internally data stores in MyISAM and INNODB table types?

2739

---

Does adding an index lock a table?

962

---

How do you concatenate strings in mysql?

1005

---

What are the functions in mysql?

955

---

Can you rename a database in mysql?

1027

---

How to dump a table from a database.

1020

---

What is the use of mysql workbench?

1017

---

How do I update a variable in mysql?

939

---

What is pdo :: fetch_assoc?

904

---

How do I create a new database in mysql?

906

---

How much does mysql cost?

921

---

What are the differences between innodb and myisam engines?

979

---