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 |
Is mysql a server?
How to connect html form to mysql database using php?
What is mysqladmin flush hosts?
What is a table schema?
How can I see mysql database?
Explain about reporting services of MYSQL?
What is the use of i-am-a-dummy flag in mysql?
How can you see all indexes defined for a table?
why not null is not allowed at table level
How to convert numeric values to character strings?
Explain about the architecture of MYSQL?
What is a longblob?