What is Inner Joints and Outer Joints ?
What is right outer joints,left outer joints,right inner
joints , left inner joints ,
- 2 Answers
- 6845 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / sunil kumar
Inner join=>Inner join returns rows when there is at least
one match in both tables.
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.
Right Outer Join=>Return all the rows of second table ,plus
matching record of both tables.
Left Outer Join=>Return all the rows of first table,plus
matching record of both tables.
| Is This Answer Correct ? | 26 Yes | 0 No |
Post New Answer View All Answers
How to use regular expression in pattern match conditions?
how we will Show selected records sorted in an ascending (asc) or descending (desc).
What is view in mysql?
What are the steps required to view your mysql database?
Is mysql relational database?
Can I use mysql for free?
How do I start mysql in linux?
What is current version of mysql?
What is information_schema in mysql?
What is mysql cursor?
How to set the time zone for MySQL to particular country time?
What is mysqli_result?
Why we use mongodb instead of mysql?
What is default password for mysql?
What are date and time functions in mysql?
