Types of joins ?

Answer Posted / reddy

Hi Friends,

1)Inner or Natural Join.
2)Non equi Join.
3)Self Join.
and 4)Outer Join.

Thanks
Reddy

Is This Answer Correct ?    9 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is cte sql?

716


Why is a primary key important?

726


How do I use google cloud in sql?

728


What is trigger price?

728


What are the different operators available in sql?

746






Does inner join return duplicate rows?

698


What does (*) mean in sql?

712


Are subqueries faster than joins?

725


What are the advantages of sql?

773


How can we solve sql error: ora-00904: invalid identifier?

882


What is difference between function and trigger?

715


What is foreign key in sql with example?

679


what is index? : Sql dba

746


Why is %isopen always false for an implicit cursor?

762


Why stored procedure is faster than query?

677