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...


please anyone explain the equi join,outer joi(right outer
join and left outer join),theta join and self join with
database tables.

Answers were Sorted based on User's Feedback



please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and..

Answer / punnaiahbabu

Equi join means equlity condition b/w tables
left outerjoin :matching and unmatching from left side onley
matched from right side.........
right outer join:matching and unmatching from right side
onley matched from left side.
outer join :matching and unmatching displed both of the tables
self join:we will right on sql query on the table.

Is This Answer Correct ?    7 Yes 0 No

please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and..

Answer / babu

Equai join: Matching records based on equality condition is
satisfied in the both the tables.
Left puter jion:All Records from left table only matcning
records form right table.
Right outer join:All records from right table and only
mating rows from left table.
theta join:Mating the records based on other than the
euality(ex:Age,Marks)
Self Join:It's a join with itself is called self join

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Business Objects Interview Questions

how to add duplicte rows to the existing report in webi ?

1 Answers   HCL,


how to restrict null values in webi report?

2 Answers   InfoStep,


Can we use two different sources in webirich client to create A report ? Like universe and excel etc...

3 Answers   PWC,


What are the types of errors you faced while creating a report from two different data providers

3 Answers   IBM,


how we improve the performance of report and universe?

4 Answers   Accenture, IBM,


CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?

2 Answers  


How to create Index to the table in the universe designer and how it improves the Query performence

0 Answers  


Explain in detail about type 1?

0 Answers  


can any one tell me how to create a new universe from scrach with step by step process.

4 Answers   HCL,


What is Cartesian product?

14 Answers  


How to get two dimension objects in a same block which are comming from two different contexts ?

1 Answers  


What is the difference between sub-query & co-related sub query?answer ASAP....... thanks in advance..............Prakash

3 Answers   iFlex, Maintec, TCS,


Categories