What are joins..how many types of joins are there?

Answer Posted / akn

In SQL Server,Join actually puts data from two or more
tables into a sinle result set.
there are 3 types of joins
1.Inner join
2.Outer join
3.Cross join

Is This Answer Correct ?    73 Yes 40 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you assign multiple query result rows to a variable?

549


How to turn on or off recycle bin for the session?

610


How to define a cusotmer as a supplier in ORACLE R12

1727


What are the different types of trigger and explain its various uses and functions?

551


How to compare dates in oracle sql?

657






Is oracle an operator?

534


What is transport network substrate (tns) in oracle?

587


Explain compound trigger in oracle?

551


In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1784


How to export data to a csv file?

627


Can we store images in oracle database?

553


how do u setup a replication site?

1501


What is a cognitive schema?

528


What privilege is needed for a user to query tables in another schema?

508


What is a table in oracle?

543