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 important is to list the column names when doing an insert?

1036

---

Write a query to select all teams that won either 1, 3, 5 or 7 games.

1354

---

How to store values to array from mysql database in php?

941

---

Is oracle better than mysql?

883

---

How do I run mysql on a mac?

960

---

How many rows we can insert in a mysql table?

958

---

What is the difference between char and varchar in mysql?

1102

---

What is slow query log in mysql?

1099

---

Is mysql free download?

847

---

How can you count the total number of records of any table?

919

---

How to return query output in html format?

926

---

How many rows can a mysql table hold?

1009

---

What do you understand by mysql terminal?

1045

---

What is the difference between unix timestamps and mysql timestamps?

1013

---

How we can get the current date in mysql?

955

---