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
- 7894 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 |
What is pragma exception?
I want to start and stop mysql on windows? How do I do that?
how to find missing numbers between two order numbers; and dates ?
What is difference between function and procedure in mysql?
when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different date 1894-07-11 any one pls help me what's wrong in my query Create table orders(od_id int,od_name varchar(10),od_date date) insert into orders values(1,'sai',22-10-2012) and any one pls suggest what i can learn for 3 years real time experenice in sql because i am looking for database field
How much does mysql cost?
In which language mysql has been written?
How many columns can be used for creating Index?
How do I switch users in mysql?
What is prepared statement in mysql?
How do I edit a trigger in mysql?
What is database migration in mysql?
-
Oracle (3259) - 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)
