Types of joins ?

Answer Posted / bipin

sql-server

inner join
outer join
left outer join
right outer join
full outer join
cross join


oracle sql

inner join
outer join
left outer join
right outer join
full outer join
cross join
natural join

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does inner join mean?

759


How can we make an if statement within a select statement?

739


Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

725


How do I debug a stored procedure?

813


What is union and union all keyword in sql?

725


What is a mutating table and a constraining table?

767


how many ways to get the current time? : Sql dba

715


Explain the difference between sql and mysql.

756


How would you pass hints to the sql processor?

710


Why do we need cursors in pl sql?

721


Is sql better than excel?

706


What is an exception in pl/sql?

730


what is the difference between myisam static and myisam dynamic? : Sql dba

773


what are the nonstandard string types? : Sql dba

806


Can we rollback after truncate?

756