SELECT FROM BASE1 BRAK WHERE LES LIKE SELECT CASE LAND WHEN Россия THE

1
2
3
4
5
6
7
SELECT * FROM BASE1.BRAK WHERE LES LIKE (
SELECT CASE LAND
WHEN "Россия" THEN "%Солодк%"
WHEN "Пакистан" THEN "%Линкас%"
WHEN "Польша" THEN "%Трихопол%"
ELSE ""
END);