Types of joins ?

Answer Posted / vinodkumar.r

2 types
1)inner join ,
2)outer join
a)left outer
b)right outer
c)full outer

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a primary key example?

706


In what condition is it good to disable a trigger?

754


Can there be 2 primary keys in a table?

738


What is asqueryable?

721


What is sql data?

717


How many disk partitions should I have?

726


What does inner join mean?

765


what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

751


Can a key be both primary and foreign?

729


What is replication id?

693


Can we use having without group by in sql?

739


What is the difference between left outer join and left join?

715


describe transaction-safe table types in mysql : sql dba

713


What is sorting in sql?

687


How do I trace sql profiler?

711