1.Self Join 2.Inner Join i.Equi-Join ii.Non-Equi Join 3.Outer Join

Types of joins ?

Question Posted / siva

Answer Posted / siva

1.Self Join
2.Inner Join
i.Equi-Join
ii.Non-Equi Join
3.Outer Join
i.Full Outer Join
11.Left Outer Join
iii.Right Outer Join

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Where do we use pl sql?

982

Why we use sql profiler?

936

How much does sqlite cost?

1021

How does rowid help in running a query faster?

1401

What are commit, rollback, and savepoint?

966

What is the difference between database trigger and stored procedure?

1056

What are the constraints available in sql?

1027

Write a query to find the names of users that begin with "um" in sql?

969

Is crud a cuss word?

1012

how to check myisam tables for errors? : Sql dba

1304

how can we find the number of rows in a table using mysql? : Sql dba

1069

What does trigger mean in psychology?

946

what is the functionality of the function htmlentities? : Sql dba

929

What does pragma mean?

1032

Explain what is rdbms?

1017