gistfile1.txt

select billings.cost, employees.name
from (
  select cost, employee_id from past_billings
  union
  select (hours * rate) as cost from future_billings
) billings
join employees on employees.id = billings.employee_id;