equi join , non-equi join, self join, outer join, cross join.

What are the different types of joins and explain them
briefly.

Question Posted / hindol

Answer Posted / hindol

equi join ,
non-equi join,
self join,
outer join,
cross join.

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can a primary key be a foreign key?

573

How do I find duplicates in a single column in sql?

530

What is the difference between jpql and sql?

549

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

713

what is 'mysqladmin' in mysql? : Sql dba

527

Why query optimization is needed?

511

What is Collation Sensitivity ? What are the various type ?

495

what is a field in a database ? : Sql dba

537

Mention what does plv msg allows you to do?

662

What is the source code of a program?

503

What is sqlite format?

626

What are the different set operators available in sql?

563

what is the difference between $message and $$message? : Sql dba

543

How many types of index are there?

546

how to delete an existing column in a table? : Sql dba

550