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 SERIAL data type in MySQL?
Why use stored procedures in mysql?
How do I select a database in mysql?
What is the usage of "i-am-a-dummy" flag in mysql?
How do I show all mysql databases?
Explain the different types of constraints?
How to load a csv file into a table
How can I change database in mysql?
What are the non-standard sql commands supported by 'mysql'?
What are the features of mysql?
What is MySQL?
What does tinyint mean?