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
- 7855 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
What is the purpose of using a heap table?
What are the method you will follow while sql installing
How do I edit a table in mysql?
How to display top 50 rows?
Do you need a license for mysql?
How do I find the size of a mysql database?
Which is faster innodb or myisam?
How do I change the max connections in mysql?
What is mysql_connect?
Is sql and mysql same?
How to write date and time literals?
What does blob mean in mysql?
how you will Create a database on the mysql server with unix shell.
What are the functions used to encrypt and decrypt the data present in mysql?
What's the difference between mysql and sql server?
