yql/essentials/tests/sql/suites/join/grace_join1.sql


1
2
3
4
5
6
7
8
9
10
11

USE plato;
pragma DisableSimpleColumns;

select
cust.customer_id, cntr.country_name
from
plato.countries1 as cntr
join
plato.customers1 as cust
on cntr.country_id = cust.country_id
where cntr.country_id = "11";