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

how to decrement dates by 1 in mysql? : Sql dba

582


What is schema in sql example?

595


What does <> sql mean?

542


What is scalar and vector?

530


What are schema-level triggers?

582






Is sql port 1433 encrypted?

576


What are sql queries used for?

535


What is pl sql architecture?

500


The select into statement is most often used to create backup copies of tables or for archiving records?

560


what is top in tsql? : Transact sql

542


what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

557


what are the limitations of identity column? : Transact sql

606


What are different methods to trace the pl/sql code?

540


How do I find sql profiler?

520


Explain commit, rollback and savepoint.

605