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

Types of joins ?

Question Posted / sam

Answer Posted / sam

)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 ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

what is a relationship and what are they? : Sql dba

1101

What are the different tcl commands in sql?

1175

How can you load multi line records? : aql loader

1076

Can there be more than one function with a similar name in a pl/sql block?

985

What is row_number () in sql?

983

What is the difference between function, procedure and package in pl/sql?

1263

what is transaction? : Sql dba

1007

describe mysql connection using mysql binary. : Sql dba

1068

Explain table and field in sql?

1062

Does sql use python?

1035

What is the purpose of a sql?

977

How to run sql functions in pl/sql?

1056

Which join is like inner join?

1028

what is csv? : Sql dba

999

How to change sql*plus system settings?

1055