grace_join1.sql 211 B

1234567891011
  1. USE plato;
  2. pragma DisableSimpleColumns;
  3. select
  4. cust.customer_id, cntr.country_name
  5. from
  6. plato.countries1 as cntr
  7. join
  8. plato.customers1 as cust
  9. on cntr.country_id = cust.country_id
  10. where cntr.country_id = "11";