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
Answer Posted / bharath
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 |
Post New Answer View All Answers
can anybody tell me about complicated object you have created
Explain is there any other repository domains rather than universe, security, document?
Is there any other repository domains rather than universe, security, document?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
How were the reports scheduled and how to resolve unexecuted documents?
how get the grand total in master-detail report?
What are the steps to do to use alerts in bo?
how to create reports on screech?
How to create Index to the table in the universe designer and how it improves the Query performence
What is the difference between absolute and relative div positioning?
Explain about a time when you discovered a more efficient way to do a work task?
Difference between zabo and webi?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?