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
- 8100 Views
- HP, I also Faced
- E-Mail Answers
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 |
Do I need python for mysql?
How can you see all indexes defined for a table?
How many ways we can we find the current date using MySQL?
Is mysql case-sensitive?
How do you index just the first four bytes of the column?
What is an index? How can an index be declared in mysql?
How can we store binary data in mysql?
what is database black box testing? : Mysql dba
Where is the mysql database stored?
Who developed mysql?
What is mysql slow query?
1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
