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

How to find the unique values if the value in the column is repeated?

0 Answers  

---

What are the 3 main types of search queries?

0 Answers  

---

Is Mysql query is case sensitive?

0 Answers  

---

What do you understand by mysql terminal?

0 Answers  

---

How many ways to get the current time?

0 Answers  

---

Write a program using the select statement, while loop.

0 Answers  

---

What is maximum size of a database in MySQL?

13 Answers   Bastioncoup, CIS, NM, V2 Solutions, Wipro,

---

Can I use mariadb instead of mysql?

0 Answers  

---

What is slow query log in mysql?

0 Answers  

---

What is mysql default port number?

0 Answers  

---

How can I see mysql database?

0 Answers  

---

In which year mysql created?

0 Answers  

---