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

Is primary key an index?

532


What is trigger in sql?

578


How long will it take to learn pl sql?

522


What is 19 null in sql?

532


What is the difference between a database and a relational database?

558






how do you login to mysql using unix shell? : Sql dba

561


What are tuples in sql?

561


what are tables and fields? : Sql dba

577


How do we accept inputs from user during runtime?

544


explain about mysql and its features. : Sql dba

543


How is indexing done in search engines?

529


table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

3337


What is lexical units in pl sql?

570


What are the different types of a subquery?

517


Explain the difference between sql and mysql.

563