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

Is it possible to update views?

947

Which software is used for pl sql programming?

970

what is an alias command? : Sql dba

1074

Why is partition used in sql?

1104

how do you know if your mysql server is alive? : Sql dba

1063

How do you write a complex sql query?

1044

How to handle bulk data?

1299

How do I debug a stored procedure?

1095

Why do we use function in pl sql?

1045

how many sql dml commands are supported by 'mysql'? : Sql dba

1098

how to include numeric values in sql statements? : Sql dba

1083

Is sql a case sensitive language?

918

How are sql commands classified?

1071

What is set serveroutput on in pl sql?

1272

Can we insert data into materialized view?

931