On 8/29/13 9:22 PM, Bastiaan Olij wrote:
Work well enough.. But as I'm using the same data in different reports
and I though a view might be smart. So I created a view:
create view v_costs as
select dcjobid as costjobid, sum(dcamount) as costamount
from directcosts
group by dcjobid
Hi all,
I've started using views in an attempt to try and simplify some of my
more complex reporting and running into some snags and I'm trying to
figure out how Postgres decides to join data with my view.
Just to present a simplified representation of what I am trying to
accomplish the following
