about join
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 1 Yes | 0 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
What is a session in mysql?
How do I create a new database in mysql?
How to delete a table.
What is mysql slow query?
What is mysql default port number?
What is the usage of ENUMs in MySQL?
How to get the current date in mysql?
What is the difference between now() and current_date()?
What is the use of mysqli_query?
How to shutdown mysql server?
How do I setup mysql?
What are the different data types in mysql?