Answer Posted / 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 |
Post New Answer View All Answers
What are Heap tables?
How do I automate a backup in mysql?
What is mysql vs sql?
How to display odd rows in student table in mysql?
Which is better sqlite or mysql?
Is mysql connect deprecated?
Explain % and _ inside like statement?
Define REGEXP?
what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL
What you can use regular expression for in mysql?
What is the difference between heap table and temporary table?
Does mysql case matter?
What is mysql cursor?
What is row level locking in mysql?
What is mysql community edition?