I have 2 tables. Table 1 is employee table and Table2 is
department table. In employee table i have 1,2,3,4,5 emp
id's,in Dept table i have various dept's like a,b,c and i
have 2,3,4 emp id's in my dept table.I joined with these 2
tables.I want the results for equi join means how many
records will fetch.In the same scenario i have to know the
left outer join, right out join and full outer join resuls
means how many records will come. can any body tell me the
answers
inner join :3 recorde
eno dept
2 a
3 b
4 c
leftouter join: 5records
1 NULL
2 a
3 b
4 c
5 Null
Rigt outer join: 3 records
2 a
3 b
4 c
Null d (if d is not assigned to any employee)
full outer join: 5records
1 Null
2 a
3 b
4 c
5 Null
Null d
Thank you.
| Is This Answer Correct ? | 35 Yes | 0 No |
Explain the difference between detect alias and detect context?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
When upgrading from 3.1 to 4.0. Which services need to run ONLY? Do ALL services need to be running?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level
Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu
What is the Computation error? how to solv it?
Can we use unconnected lookup as dynamic lookup?
How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?
Difference between b.o 5.1 and 6.1b?
What do you mean by Object qualification?
What is the difference b/w the simple Universe and Complex Universe?