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.

What is text?

0 Answers  

---

Print 3 highest salary

9 Answers  

---

Write a query to display even rows in student table using mysql?

0 Answers  

---

Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command

5 Answers   Amdocs, MediaSoft,

---

What sql does mysql use?

0 Answers  

---

What is mysql primary key?

0 Answers  

---

What are the different table present in MYsql?

3 Answers  

---

What is the use of mysql_fetch_array () function in php?

0 Answers  

---

Is it possible to update a table value with out using update command?. if yes what is the reason, if no what is the reason?.

1 Answers  

---

What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

0 Answers  

---

what is the difference between between and in operators in mysql?

0 Answers  

---

How do I select a table in mysql?

0 Answers  

---