what are the different types of joins?

Answer Posted / prakash

Proprietary Joins
----------------
EquiJoin
Non EquiJoin
Self Join
outer join

Compliant Joins
---------------
Cross Join
Natural Joins
Full or two sided outer joins
Arbitrary Joins

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is recursive stored procedure? : Sql dba

714


What is a call statement? Explain with an example.

743


What is dbo in sql?

704


What are three advantages to using sql?

730


Does a user_objects view have an entry for a trigger?

755






What is normalization? How many normalization forms are there?

747


What company owns postgresql?

769


Explain 3 basic parts of a trigger.

1037


What is an inconsistent dependency?

761


How do I view stored procedures?

737


Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

757


How to create an array in pl/sql?

771


What is coalesce in sql?

732


What is set transaction?

763


What is a trigger word?

727