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
- 7857 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is innodb_buffer_pool_size?
What is dump in mysql?
What is database engine in mysql?
Is mysql free software?
What is datatype in mysql?
What is bdb (berkeleydb)?
How do I change the max connection in mysql?
What is the command line end user interface - mysql?
Does facebook still use mysql?
What is mysql cursor?
Can we use mysql and mysqli together?
What you can use regular expression for in mysql?
How do I stop a mysql command?
What is the difference between having and where clause in mysql? Explain
What do we use to remove duplicate records while fetching a data in mysql ?
