What is Inner Joints and Outer Joints ?
What is right outer joints,left outer joints,right inner
joints , left inner joints ,
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
What is query design?
How do I show users in mysql?
How do I edit a database in mysql workbench?
How do you flush privileges?
Is blocked because of many connection errors mysql?
How do I remove a user from mysql?
What is unsigned in mysql?
What is offset limit?
What is difference between mysql and mysql workbench?
How to check if a record exists in a mysql database php?
What are the purposes of using enum and set data types?
What is text in mysql?
What are mysql functions?
What is 1nf 2nf 3nf?
How can you validate emails using a single query?