Types of joins?

Answer Posted / roopesh kumar

(1) Inner or Equei join
(2) Outer or no - equei join
(a) left outer
(b) right outer
(c) full outer
(3) Cartision or cross join
(4) Self join
(5) Natural join

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the packages in pl sql?

568


What are the set operators in sql?

549


Which is better trigger or stored procedure?

498


Difference between global and parameter variables?

1453


how to enter binary numbers in sql statements? : Sql dba

487






How do I run a pl sql program?

627


What are the three forms of normalization?

522


Difference between truncate, delete and drop commands?

557


How to Declare Fixed Length String Value In PL SQL

659


What are analytic functions in sql?

547


Can pl sql procedure have a return statement?

548


What are the 3 modes of parameter?

675


How can I speed up sql query?

522


What is sharding in sql?

561


How do I start sql profiler?

555