Interested to Buy Any Domain ? << Click Here >> for more details...
What is Inner Joints and Outer Joints ?
What is right outer joints,left outer joints,right inner
joints , left inner joints ,
- 2 Answers
- 7993 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / muthuk
Outer Join=> Outer Join returns the set of all matching
records from both tables. Outer join doesn`t require each
record to be matched in both the tables.
Inner join=>Inner join returns rows when there is at least
one match in both tables.
Left Outer Join=>Return all the rows of first table,plus
matching record of both tables.
Right Outer Join=>Return all the rows of second table ,plus
matching record of both tables.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How to calculate the difference between two dates?
How to use triggers to track changes in mysql?
What is the difference between myisam dynamic and myisam static in mysql?
What is the difference between procedure and function in mysql?
What is the maximum size of mysql database?
What is the usage of ENUMs in MySQL?
What is the use of mysqli_query?
Which is faster mysql or mongodb?
How to display nth highest salary from a table in a mysql query?
How to set mysql variable in php?
Can mysql store files?
How do I change directories in mysql?
Can we store images in mysql database?
What ascii 31?
What is int mysql?
