Answer / hrindows@gmail.com

The SQL statement that is used to make a connection between two or more tables based on the matching columns is called a join. It is mainly used for complex queries.
Different types of SQL joins are mentioned below:
 Inner Join: It is a default join. It returns records when the values match in the joining tables.
 Left Outer Join: It returns all the records from the left table based on the matched records from the right table.
 Right Outer Join: It returns all the records from the right table based on the matched records from the left table.
 Full Outer Join: It returns all the records that match from the left or right table.

How can you export the table as an xml file in mysql?

0 Answers  

---

How do I install and use mysql?

0 Answers  

---

What is mysql sleep process?

0 Answers  

---

What is federated tables in mysql?

0 Answers  

---

What is the use of mysqli_fetch_assoc?

0 Answers  

---

---

What is the usage of regular expressions in mysql?

0 Answers  

---

How can you change the name of any existing table by using the sql statement?

0 Answers  

---

What is DCL in MySQL?

1 Answers  

---

Where is the mysql data directory?

0 Answers  

---

How can I see all mysql databases?

0 Answers  

---

What causes mysql too many connections?

0 Answers  

---

What is the difference between mysql_connect() and mysql_pconnect()?

7 Answers   TCS,

---