What is equi-join?

Answer Posted / aryasen vaikom

An equijoin is a join with a join condition containing an
equality operator ( = ). An equijoin combines rows that have
equivalent values for the specified columns.
Eg: select * from emp,dept where emp.deptno=dept.deptno;

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When does checkpoint occur in dbms?

605


How to specify transaction or query timeout?

538


What are the basic components of notification services?

477


What is rdbms and its features?

533


Mention the different types of dbms.

491






what are the different integrity rules present in the dbms?

496


What is the difference between a database and a spreadsheet?

469


What are records and fields in a database?

459


What is database management system explain?

520


Explain some of the uses of openedge architect features useful for a developer?

469


What is dbms architecture?

580


Explain environment of openedge?

539


What is e-r model in the dbms?

560


What is join? Mention its types.

628


What is 2-tier architecture?

493