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

521

---

Is mysql still popular?

484

---

How we can see all indexes defined for a table in mysql?

478

---

How do I view a mysql database?

475

---

what is constraints? Also explain the different types of constraints?

516

---

---

What language does mysql use?

428

---

How do you say mysql?

480

---

What is trigger in mysql with example?

484

---

Is mysql distributed?

489

---

Why use stored procedures in mysql?

515

---

What does "i_am_a_dummy flag" do in mysql?

495

---

What does mysql flush hosts do?

468

---

How do I rename a mysql database?

487

---

Is mysql open source?

470

---

What is triggers and how it can be used in mysql?

522

---