Answer / mala yadav

select command is used to fetch the result from the table ,
but of u want the combine results from more than 1 table
then in this case we use JOINS rather than a single table
select statement.

In joins u can join upto 2 to 61 tables to get tha required
result.

joins are of 5 types
- inner join
- self join
- cross join
- left outer join
- right outer join

Answer / vishal

if u donot know join means u always working in one table but
always single table is not enough to give the result than
comes the concept of joins in which two table we join must
have a column same on the basis of the table are join. join
are of various type such as left outer, right outer ,inner
join etc

What are queries used for?

0 Answers  

---

What is the use of mysql_close()?

0 Answers  

---

How do I kill a mysql connection?

0 Answers  

---

What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?

2 Answers  

---

What is clob in mysql

0 Answers  

---

How to insert dynamic values in mysql using php?

0 Answers  

---

Where MyISAM table will be stored and also give their formats of storage?

0 Answers  

---

write a query to mysql in safe mode and to change the root password

0 Answers  

---

What is mysql port?

0 Answers  

---

How do you insert a table?

0 Answers  

---

How to delete a trigger in mysql?

0 Answers  

---

What is mysql database used for?

0 Answers  

---