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 do you need to connect php to mysql?

0 Answers  

---

In the below example, how many String Objects are created? String s1="I am Java Expert"; String s2="I am C Expert"; String s3="I am Java Expert";

1 Answers  

---

What are the 3 main types of search queries?

0 Answers  

---

What is the maximum number of columns per table?

0 Answers  

---

how to declare unique key in creating a table..?

2 Answers  

---

---

How can you plan the logshipping before processing?

0 Answers   ACC,

---

What is flush privileges in mysql?

0 Answers  

---

What are the mysql database files stored in system ?

0 Answers  

---

What are date and time data types?

0 Answers  

---

How do I download mysql?

0 Answers  

---

How can we run batch mode in mysql?

0 Answers  

---

I want to find out all databases starting with ‘test’, I have access to?

0 Answers  

---