Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nareshkumar
A join is a condition that links the data in seperate but
related tables. The tables usually have a parent-child
relationship. If a query does not contain a join, the
database returns a result set that contains all possible
combinations of the rows in the query tables.
Types of joins:
1) Equi-Joins
Link tables based on the equality between the values in the
column of one table and the values in the column of another.
2) Theta Joins
Link tables based on a relationship other than equality
between two columns.
3) Outer Joins (Left Outer, Right Outer, Full Outer)
Link two tables, one of which has rows that do not match
those in the common column of the other table.
4) Shortcut Joins
Join providing an alternative path between two tables,
bypassing intermediate tables, leading to the same result,
regardless of direction. Optimizes query time by cutting
long join paths as short as possible.
5) Self restricting joins
Single table join used to set a restriction on the table.
| Is This Answer Correct ? | 24 Yes | 4 No |
Post New Answer View All Answers
Explain about a time when you discovered a more efficient way to do a work task?
How were the reports scheduled and how to resolve unexecuted documents?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
what are the tables used in health care domain project and columns used in report?
What is the functional & architectural differences between business objects and web intelligence reports?
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 ?
Explain when we use aggregate awareness function in designer?
What is a fantrap in business objects?
can anybody tell me about complicated object you have created
how to prepare the documentation in business objects and where to get the requirement?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
What is the difference between condition & filter?
How would you format some text using css to be verdana and bold?
