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
- 8101 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
using primary can we relate two table, with out foreign key?
What is the maximum no of columns a table can have?
What is difference between mysql and mysql server?
How do I find my mysql username and password?
Which statement is used to delete a table in MySQL.
How to list or view all databases from the mysql server.
List data types in mysql? Explain
What is the purpose of mysql database?
What is normalization and list the different types of normalization?
What is the difference between unix timestamps and mysql timestamps?
What is mysql cursor?
What is meant by decimal (5,2)?
How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
What are federated tables?
Why mysql is used with php?
