Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Database Management
  2. Suggest New Category

What are the Different Types of Joins and How do They Work?

Question Posted / hr@tgksolutions.com


What are the Different Types of Joins and How do They Work?..

Answer / hr@tgksolutions.com

Using an inner join, records from both tables with matching values are retrieved.
All records from the left table and matched records from the right table are retrieved using a left join, also known as a left outer join. Records from the right table that don't match will be NULL.
All records from the right table and matched records from the left table are retrieved using a right join, also known as a right outer join. Records from the left table that don't match will be NULL.

When there is a match in either the left or right table, records are retrieved using a full join (full outer join). Records from both tables that don't match will be NULL.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Database Management Interview Questions

Oracle precompiler translates the EMBEDDED SQL statemens into ?

1 Answers  

What are the types of model?

0 Answers  

WHAT IS INDEXING?

3 Answers   Patni,

How do you maintain a database?

0 Answers  

What is a field in database?

0 Answers  

i want to know real time experience on oracle dba anybody help me please mail me aniltelkar50@gmail.com

1 Answers   IBM,

How to recreate the index on a firebird table?

0 Answers  

What are fact tables and dimension tables ? What is dimensional modeling and star schema design

0 Answers  

Explain the functionality of dml compiler.

0 Answers  

What is different keys in dbms?

0 Answers  

describe and contrast a trigger and a procedure.

0 Answers  

How to Optimize Database Queries for Performance?

1 Answers  

For more Database Management Interview Questions Click Here
Categories