Advertisement
Guest User

Untitled

a guest
May 26th, 2019
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.15 KB | None | 0 0
  1. select k.name nazwa, m.name stolica
  2. from country k
  3. left join city m on capital = id
  4. where k.name like "%y" and (m.name is null or m.id = k.capital);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement