What is a join? Explain different types of joins?

Answer Posted / srinu

Combining a data from multiple tables is called join.
There r 5 types of joins r there.
1)Simple join 2)Equi join 3)Outer join 4)Theta join
5)Short cut join

Is This Answer Correct ?    4 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between user and versatile user?

585


Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

687


What is thumbnail?

582


When to use local filter and when to use global filter?

603


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 ?

1572






Difference between b.o 5.1 and 6.1b?

653


Explain about alerts in bos, under what situation we need to use alerts?

560


Explain what would you consider as your biggest achievement and why?

578


Explain the difference between detect alias and detect context?

629


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

600


Explain how many universes can be created in a project?

620


what will be the contents for a functional requirements specifications

1793


Explain difference between zabo and webi?

656


What are the data types present in bo? What happens if we implement view in the designer and report?

622


Which command using Query Analyzer will give you the version of SQL server and operating system ?

4193