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
- 5311 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 |
5.what is LOV? where it is store?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
What is the architecture of ur project? can u explain it? PLz
I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run?
what is zero client and thin client ?
What is mean by tuning the report?
What is drill across ? can anybody explain me in detail?
What is package in BO
When we r going for Short_cut join & It's Resolution??? Plz provide one scenario??
Can we Save (save as) WEBI Doc as DESKI?
what is isolated joins in check integrity
How to create a report template BO XI R2
Teradata 
