What is Inner Joints and Outer Joints ?
What is right outer joints,left outer joints,right inner
joints , left inner joints ,
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What are the advantages of mysql?
How many rows can mysql hold?
How to rename an existing table in mysql?
Write a query to find duplicate rows in table?
How do I fix a crashed mysql database?
What is DDL in MySQL?
What is mysql default port number?
How to show all tables with 'mysql'?
What is a mysql view?
How many ways we can we find the current date using MySQL?
Can mysql store files?
What is full text indexing in mysql?