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
- 5343 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 |
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
How do you restrict access to rows of a database?
why do we use crystal reports rather than webintelligence reports ?
How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?
how to create reports on screech?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGNING UNIVERSES?
main purpose of aggregate awareness(not include make possible of use of aggregate tables)
How to get red line in the graph at some point (value)? Example : In graph at 200000 value
i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?
Explain what would you consider as your biggest achievement and why?
What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...
WHAT DOES SQL TAB CONTAIN?
Teradata 
