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 to return query output in html format?

877

---

How do I tune a mysql query?

826

---

How to use rank function in mysql?

917

---

How can you change the password of a mysql user?

910

---

How is myisam table stored?

914

---

What is mysql default port number?

964

---

What is 'mysqlcheck'?

963

---

How can I compare two mysql databases?

902

---

How to show certain selected rows with the value "pcds".

887

---

What is 'mysqld'?

877

---

What is mysql database used for?

956

---

How do I start and stop mysql server?

941

---

How to check if a record exists in a mysql database php?

839

---

What is data types in mysql?

862

---

How to copy data from one server to another using php?

978

---