1-Inner Join 2-Outer Join 3-Left Join 4-Right Join 5-Self Join

What are different types of joins ?

Question Posted / amar misra

Answer Posted / amar misra

1-Inner Join
2-Outer Join
3-Left Join
4-Right Join
5-Self Join

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which is better join or subquery?

1191

Who developed sql?

1100

what is sql server agent? : Sql dba

1158

What are the possible values that can be stored in a boolean data field?

1042

What is java sql connection?

1120

What is data control language (dcl)?

1206

How do I count duplicates in sql?

1178

What is group function in sql?

1067

what is the difference difference between procedure and packages

10549

What is the difference between row level and statement level trigger?

1072

What is update query?

1035

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1068

Does sql use python?

1095

What are the types of views in sql?

1142

Why do we use sql constraints?

1215