Subject subselect
Author Moravecz László
If IB know this select:
select city, country, (select currency from country B where A.country =
B.country) from customer A;

why don't know it:
select city, country, (select currency, country from country B where
A.country = B.country) from customer A;

eMeL