Re: [SQL] alias problem on join

Dnia 2004-02-06 12:38, Użytkownik Gary Stainburn napisał: Hi folks, I've got an accounts table and a transactions table and want to do a summary join. If I do: bank=# select aid, aname, aodraft from accounts a bank-# left outer join (select account, sum(amount) as balance bank(# from statement

[SQL] alias problem on join

Hi folks, I've got an accounts table and a transactions table and want to do a summary join. If I do: bank=# select aid, aname, aodraft from accounts a bank-# left outer join (select account, sum(amount) as balance bank(# from statement group by account) as s bank-# on s.account = a.aid; I get