There are three types of joins: Inner Join, Outer Join, Cross Join

Can you explain the types of Joins that we can have with Sql
Server?

Question Posted / guest

Answer Posted / guest

There are three types of joins: Inner Join, Outer Join,
Cross Join

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are views in ms sql server?

1080

What is the difference between having clause and where clause in sql server?

1098

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1161

Can you explain what are commit and rollback in sql?

940

ow to bring suspect mode datbase online from scratch

1804

Who developed sql server?

936

What are two difference between sql azure and azure tables?

159

What is service broker?

1005

Why we use the openxml clause?

1011

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

967

Why do we need normalization?

922

What is the difference between rank and dense_rank?

1081

Explain can SSRS reports Cache results?

158

What is dbcc? Give few examples.

1027

What is data source document?

1038