equijoin

Example:The inner equijoin query returned all the employees and their managers who work in the same department.

Definition:A specific type of equijoin where only the matching records from both tables are returned.

Example:An outer equijoin between the sales and customer tables provided a list of customers who made purchases as well as those who did not.

Definition:A type of equijoin that can include non-matching records from one or both tables, producing a result set that includes all the records from at least one table.

Example:A natural equijoin between orders and customers was performed by the database system because both shared a customer ID column.

Definition:An equijoin that combines rows from two tables based on columns with the same name in both tables, without requiring an explicit condition.