what is a join? what are the types of joins?
- 5 Answers
- 8395 Views
- HCL, Satyam, I also Faced
- E-Mail Answers
Answer Posted / m m naidu
JOIN: A join is a query using which we can query data from
more than one table
TYPES OF JOINS:
1.EQUI JOIN
2.SELF JOIN
3.OUTER JOIN
a.left outer join
b.right outer join
c.full outer join
4.cartesian join
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is set to be cardinality?
can we insert all types of charts in a list report? what r the realtime prompts?
What is meant by junk dimension?
What is meant by drill down?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
What are all the types of report?
what are the dimensions that you have in your current project?list them?
Write some methods to apply securities in framework manager model?
Define dimensions?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
Diff b/w Crossproduct and Outerjoin?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
What are the main services provided by application tier?
