The SQL join command is used to join two or more tables. At times you may

explain different types of jions with examples briefly?

Question Posted / vijay

3 Answers
10422 Views
Zensar, I also Faced
E-Mail Answers

Answer Posted / vijay

The SQL join command is used to join two or more tables. At
times you may need to join two or more tables to retrieve
the information you need from your SQL database

Types Of Joins-
1.Inner Join
2.Outer Join -types -
left Outer,
Right Outer,
Full Join

3.Cross Join
4.Self Join

Is This Answer Correct ?

13 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is dirty page?

952

Explain indexes disadvantages?

1065

What are the restraints imposed on the table design by a merge replication?

1020

How is table type constraint applied to a table?

961

Explain what are the database objects? : SQL Server Architecture

1058

What is reportserver and reportservertempdb ?

152

How to scale out a federation by Sql statement?

116

When is update_statistics command used?

1023

What is the exact numeric data type in sql?

986

Can select statements be used on views in ms sql server?

1048

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

Can we use having clause without group by?

959

Explain “not null constraint” in sql server?

1007

What is a livelock?

942

Can we hide the definition of a stored procedure from a use?

1199