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
- 4686 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 |
how to schedule a report for even number dates?
what is the difference b/w star and snowflack schema in dataware house?
How to Shedule the reports in Xi R2
What task is 98% of the required work of a business analyst?
How to create Universe using Flat file in BO6.0
2.What is loop? How resolve the loop?explain it?
11 Answers TCS, UHG,
IS THERE ANY MINIMUM RQUIREMENT TO DEFINE CONTEXT?
can we cretae views in universe level?
What is the difference between the public object&schema object?
How we drill up week to month?
What is the most complex report you have developed. Explain and how did you overcome??? Please give some examples
how to creat 2 way drilling mode.can any one know this
Teradata 
