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

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

Question Posted / pradeep

2 Answers
6484 Views
Wipro, I also Faced
E-Mail Answers

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 find the size of the report

1 Answers

What is a fantrap in business objects?

0 Answers

how do u resolve contexts ?

6 Answers Wipro,

how to restrict up to three levels in hierarchy when u do drill mode?

3 Answers iGate,

I HAVE DRAGGED OBJECTS IN QUERY PANEL.... IF I CHECK THE SQL QUERY IT WAS SHOWING 2 QUERIES IN WHAT SITUATION IT WILL HAPPEN?

2 Answers Accenture,

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

1 Answers Wipro,

What is the size of data base?

2 Answers

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

2 Answers

1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?

1 Answers Virtusa,

what is performance tunning in BO in report level& designer level?

1 Answers IBM,

what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance

3 Answers Patni,

what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash

2 Answers

For more Business Objects Interview Questions Click Here