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

How do I convert a spreadsheet to a database?

537


I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?

2229


What is dbms function?

600


What is the purpose of a field in a database?

525


What is order by clause?

619






Can you explain insert, update and delete query?

628


How many types of data are there?

579


How do you create a simple database?

606


How to connect Silverlight application to database?

636


What is openedge workgroup rdbms?

675


What is oracle block?

569


What is like operator for and what are wild cards?

559


What is the importance of a database?

563


What is ordbms with example?

580


What is the purpose of a database table?

524