Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 5274 Views
- IBM, I also Faced
- E-Mail 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 |
date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2
What is detailed Object
Can you please send me the migration related issues .
plz tell me about BOmain key in detail?
what is incompactabulity error in sap bo
wat is the difference between full clinet report and thin client report?wat is the difference between desktop intelligence and web intelligence?
what is the difference between breaks and sections?
Explain how many universes can be created in a project?
What is difference between merged dimension and forced dimension??
Explain in detail about type 1?
Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please
Explain in detail about type 2(scd),
Teradata 
