what is a join? what are the types of joins?
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 r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
Name the types of gateway?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
Diff b/w Crossproduct and Outerjoin?
Define the slice and dice?
Define query items?
How to Reset Pagenumbers in one report.
what do u mean by bridge group? where we r using this one?
Give me any example of semi and non additive measures?
What is difference between data mart and data warehouse?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
what is a prompt value in report studio and variables ?
What is looping and how to avoid it in framework manager?
What is the advantage of using shortcuts?
What is the metric store database?