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
Why should I learn mysql?
How do I delete a table in mysql workbench?
Are stored procedures precompiled?
How do I import database through command line?
Can you tell what are various ways to create an index?
Is mysql a scripting language?
In which language it is written?
How would you enter characters as hex numbers?
Does mysql scale well?
What is the default password for mysql?
Is oracle better than mysql?
Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?
What can I do with mysql?
What is a delimiter in mysql?
What is database engine in mysql?
