Re: Order by not working with join

[Peter Brawley]

Then you need to aggregate it in the conventional way, eg ...

select 
  e.employee_id, e.employee_name,
  e.salary, tx.txsum, 
  e.salary-txsum as net, s.money_amount as lastamt
from employees e 
join (
  select employee_id, sum(money_amount) as txsum, max(salary_transaction_id) as txlast
  from salary_transaction
  group by employee_id
) tx using(employee_id)
join salary_transaction s on tx.txlast=s.salary_transaction_id
where e.employee_id = 1;