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

how to join two table?

Question Posted / guest

Answers were Sorted based on User's Feedback



how to join two table? ..

Answer / partha

There are two types of join inner join and outer join.

(1)Inner join will return all the common records in both the
table
Ex: Select e.ename from Employee e,Dept d where e.did=d.did;

(2)Outer join is of 3 types Left Outer,Right Outer and full
outer.
Left outer retrieves common records from both the table and
all the record from the left table.
Similarly Right Outer all the records from right table and
Full outer from both the tables

Is This Answer Correct ?    21 Yes 0 No

how to join two table? ..

Answer / n

Inner and outer joins

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Database Management Interview Questions

what are the differences between an exclusive lock and a shared lock?

0 Answers  

Explain the advantages of rdbms?

0 Answers  

what is the age limit for groups1 examination

0 Answers   APPSC,

Explain Enterprise Resource Planning (ERP), and what sort of a database is utilised in an ERP application?

0 Answers   DELL,

If an UNIQUE KEY constraint on DATE column is created, will it accept duplicate values?

2 Answers  

What is a database management system and give examples?

0 Answers  

Explain the hierarchical database?

0 Answers  

What is the function of DML Compiler?

0 Answers   Amazon, iNautix,

Where the Databases overall structure is maintained ?

1 Answers  

What is openedge translation manager?

0 Answers  

What is different keys in dbms?

0 Answers  

What is user and end user?

0 Answers  

For more Database Management Interview Questions Click Here
Categories