Equijoin

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Some parts in the output code are omitted for clarity reasons.

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

Order by clause added because the result order may vary between Oracle and Snowflake.

Since the result set is too large, the Row Limiting Clause was added. You can remove it to retrieve the entire result set.

Check this section to set up the sample database.

Basic Equijoin case

Oracle

Query

IN -> Oracle_01.sql

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;

Result

|LAST_NAME|JOB_ID  |DEPARTMENT_ID|DEPARTMENT_NAME |
|---------|--------|-------------|----------------|
|Abel     |SA_REP  |80           |Sales           |
|Ande     |SA_REP  |80           |Sales           |
|Atkinson |ST_CLERK|50           |Shipping        |
|Austin   |IT_PROG |60           |IT              |
|Baer     |PR_REP  |70           |Public Relations|

Snowflake

Query

OUT -> Oracle_01.sql

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;

Result

|LAST_NAME|JOB_ID  |DEPARTMENT_ID|DEPARTMENT_NAME |
|---------|--------|-------------|----------------|
|Abel     |SA_REP  |80           |Sales           |
|Ande     |SA_REP  |80           |Sales           |
|Atkinson |ST_CLERK|50           |Shipping        |
|Austin   |IT_PROG |60           |IT              |
|Baer     |PR_REP  |70           |Public Relations|

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.