Equijoin
Description
An equijoin is an implicit form of the join with a join condition containing an equality operator. For more information for Oracle Equijoin, check here.
No special transformation is performed for this kind of Join since Snowflake supports the same syntax.
Sample Source Patterns
Basic Equijoin case
Oracle
SELECT last_name, job_id, hr.departments.department_id, department_name
FROM hr.employees, hr.departments
WHERE hr.employees.department_id = hr.departments.department_id
ORDER BY last_name
FETCH FIRST 5 ROWS ONLY;
Snowflake
SELECT last_name, job_id, hr.departments.department_id, department_name
FROM
hr.employees,
hr.departments
WHERE hr.employees.department_id = hr.departments.department_id
ORDER BY last_name
FETCH FIRST 5 ROWS ONLY;
Known issues
1. Results ordering mismatch between languages
The result of the query will have the same content in both database engines but the order might be different if no Order By clause is defined in the query.
Related EWIs
No related EWIs.
Last updated