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

What is a parameter file in oracle?

550


Can we write dml statement in function in oracle?

625


What is oracle latest version?

572


What is the difference between translate and replace in oracle?

639


What is blob datatype?

559






What happens if variable names collide with table/column names?

574


Explain about functional dependency and its relation with table design?

544


How to run create database statement again?

613


how the indexes are stored in the Oracle Database?

1732


What is Trigger in Oracle?

565


How to get a list of all user accounts in the database?

599


What is the difference between substr and instr?

511


Explain what are the different type of segments?

572


How to generate query output in html format?

558


How to create tables for odbc connection testing?

485