• Home
• io.prestosql
• presto-product-tests
• 346
• source code
• right_join_left_join.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql-tests.testcases.join.right_join_left_join.sql Maven / Gradle / Ivy

-- database: presto; groups: join; tables: nation, region, part
SELECT p_partkey,
       n_name,
       r_name
FROM   part
       RIGHT OUTER JOIN nation
                     ON n_regionkey = p_partkey
       LEFT OUTER JOIN region
                    ON n_nationkey = r_regionkey