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
- 8007 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 default port for mysql server? : Mysql dba
How do I insert an image into mysql workbench?
How can I connect mysql database?
List the different types of normalization?
What is mysql connector used for?
What is a crosstab query?
What is blob and text in mysql?
Which command is used to view the content of the table in mysql?
What is mysql default port number?
What are the 3 main types of search queries?
What is difference between unix timestamp and mysql timestamp?
Why to use char instead of varchar in the database?
How to check server status with 'mysqladmin'?
Where is mysql password stored?
Where is the mysql database stored?
