I am trying to develop a query that will report on hours by cost type and indirect hours. I am having great difficulty.
Indirect time entries will have a prtimeentry.prassignmentid value of NULL
So if you do a join between prtimeentry.prassignmentid and prassignment.prid (as you are now) without making it a left outer join, then you will be excluding all the indirect time entries. Alternatively, you'd need to add a UNION to your query that stops short of joining to prassignment and any further tables, and just asks for results where prtimeentry.prassignmentid is null.
Retrieving data ...