sql-tests.testcases.join.explicit_inner_join_select_where.sql Maven / Gradle / Ivy
-- database: presto; groups: join; tables: nation, region
select n_name, r_name from nation join region on nation.n_regionkey = region.r_regionkey where n_name > 'E'
-- database: presto; groups: join; tables: nation, region
select n_name, r_name from nation join region on nation.n_regionkey = region.r_regionkey where n_name > 'E'