1)Inner Join a)Equi join b)Natural Join c)Cross Join 2)Outer Join

Types of joins ?

Question Posted / anuadarsh

Answer Posted / anuadarsh

1)Inner Join
a)Equi join
b)Natural Join
c)Cross Join
2)Outer Join
a)Left join
b)Right join
c)Full join
3)Self Join

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Can we rollback after truncate?

1027

Explain the difference between 'between' & 'and' operators in sql

996

which operator is used in query for pattern matching? : Sql dba

1002

How do I truncate a word?

1083

What is 19 null in sql?

956

How long it takes to learn pl sql?

1009

What is sql query optimization?

1109

What is the difference between drop and truncate commands?

1055

What is procedure explain with example?

955

What is example of database?

1051

What is a pdo connection?

1025

Write a sql query to find the names of employees that begin with ‘a’?

1008

What is data modelling in sql?

1014

What is cartesian join in sql?

1115

What is the default isolation level in sql server? : Transact sql

1020