Interested to Buy Any Domain ? << Click Here >> for more details...
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 is int unsigned?
What is sharding in mysql?
Difference between CHAR and VARCHAR?
Can we rename database in mysql?
How can you create and drop view in mysql?
What is the difference between mysql_connect and mysqli_connect?
What ascii 31?
How triggers can be used in mysql?
What is meant by sharding?
Explain % and _ inside like statement?
What are the purposes of using enum and set data types?
What is use of mysql?
How to return query output in html format?
What are date and time data types?
Does mysql case matter?
