All Downloads are FREE. Search and download functionalities are using the official Maven repository.

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

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





© 2015 - 2024 Weber Informatics LLC | Privacy Policy