And I want to read the data from accounts and present it in table-like view:

owner currency1 currency2 currency3
1 0 0 0
2 10 20 30
3 0 5 10

Where owner is ID of accounts.owner, currency1,2,3 - (SELECT id FROM currency WHERE name = '1',etc)

I can get such result only for one specific ID:

SELECT
SELECT amount FROM accounts WHERE currency = (SELECT id FROM currency WHERE name = 'currency1') AND owner = @user) AS [currency1],
SELECT amount FROM accounts WHERE currency = (SELECT id FROM currency WHERE name = 'currency2') AND owner = @user) AS [currency2],
SELECT amount FROM accounts WHERE currency = (SELECT id FROM currency WHERE name = 'currency2') AND owner = @user) AS [currency2]

Is it possible to get the same result for every object in users table? Without using Reporing Service, etc.