04 May 2009

DBMS: Equijoin (Definitions)

"A join based on equality." (Karen Paulsell et al, "Sybase SQL Server: Performance and Tuning Guide", 1996)

"A join in which the values in the columns being joined are compared for equality, and all columns are included in the results." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)

"A join using the equals operator in the join expression." (Peter Gulutzan & Trudy Pelzer, "SQL Performance Tuning", 2002)

"A join between two tables where rows are returned if one or more columns in common between the two tables are equal and not NULL." (Bob Bryla, "Oracle Database Foundations", 2004)

"A join operator where the join condition involves equality." (S. Sumathi & S. Esakkirajan, "Fundamentals of Relational Database Management Systems", 2007)

"A join based on matching identical values." (Jan L Harrington, "Relational Database Design and Implementation" 3rd Ed., 2009)

"A join that combines two tables based on matching (equivalent) data in rows in the two tables." (Jan L Harrington, "SQL Clearly Explained" 3rd Ed., 2010)

"A join operator that links tables based on an equality condition that compares specified columns of the tables." (Carlos Coronel et al, "Database Systems: Design, Implementation, and Management" 9th Ed., 2011)

"A join in which the values in the columns being joined are compared for equality, and all columns are included in the results." (Microsoft, "SQL Server 2012 Glossary", 2012)

"A join whose join condition contains an equality operator." (Oracle, "Database SQL Tuning Guide Glossary", 2013)

"A join whose join condition uses only the equals predicate." (Sybase, "Open Server Server-Library/C Reference Manual", 2019)

No comments:

Related Posts Plugin for WordPress, Blogger...

About Me

My photo
Koeln, NRW, Germany
IT Professional with more than 24 years experience in IT in the area of full life-cycle of Web/Desktop/Database Applications Development, Software Engineering, Consultancy, Data Management, Data Quality, Data Migrations, Reporting, ERP implementations & support, Team/Project/IT Management, etc.