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
What is a heap in sql?
How do you explain an index number?
what does myisamchk do? : Sql dba
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What is the difference between left and left outer join?
Explain what is an index?
What are commit, rollback, and savepoint?
What is trigger in sql? Explain
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What is mutating trigger?
What is spool?
what is the difference between delete and truncate commands? : Sql dba
What is equi join in sql?
What is view explain with example?
Are stored procedures faster than queries?