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

What is maximum number of promts we can give in a BO report?

1 Answers Patni,

8. How much supervision have you typically received in your previous job?

0 Answers CST,

define universe parameters?

5 Answers

Report have 10000 records,how to restrict the end user to 1000 Records?

6 Answers

HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?

2 Answers Polaris,

Is it possible to create a user defined Calendar in BOXIR2? If yes, then how? Ex:- I want to create a Calendar where the year starts with the month of Feb-1. Each month is of 28 days. 1st Month as 1-feb to 28-feb. 2nd Month as 29 Feb - 21 Mar. Please help me out to get the answer....

1 Answers

what is the use of merge option in webi reports? explain with example?

2 Answers TCS,

I want to do on drill calculation? Actually My report is like Continent Amount(Global Currency in dollar) ASIA 200 UK 100 On Drill ASIA Country Amount INDIA 5712(120*47.6) SINGAPORE 128(80 * 1.6) On Drill INDIA State Amount DELHI 3712 CHENNAI 2000

2 Answers

how to do scheduling in desktop intelligence in BO XI R2

3 Answers

What is global filters and local filters

3 Answers IBM,

what is difference between folders and category ?

4 Answers Tech Mahindra,

How to take backup of CMS database and Auditing database, please suggest me with a best possible ways.?

1 Answers

For more Business Objects Interview Questions Click Here