I think this needs a
GROUP BY a.Project_PK
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
From: mailto:firebird-support@yahoogroups.com
Sent: Tuesday,
@yahoogroups.com /divdivDate:09/16/2014 12:16 PM
(GMT-05:00) /divdivTo: firebird-support@yahoogroups.com /divdivSubject:
Re: [firebird-support] Re: SubQuery Help /divdiv
/divI think this needs a
GROUP BY a.Project_PK
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download
, September 16, 2014 6:38 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: SubQuery Help
Yes it does. I posted a correction but apparently it never made it
Dixon
[Non-text portions of this message have been removed]
Thanks everybody. I'll try it out.
select
a.Project_PK,
PC.b_cost AS Sum_of_Cost,
PC.b_estimate_cost AS Sum_of_Estimated_Cost,
PQ.c_qty AS Sum_of_Quantity,
PQ.c_estimate_quantity AS Sum_of_Estimated_Quantity
FROM Projects a
LEFT JOIN
(
select
b.project_pk,
sum(b.cost) as b_cost,
sum(b.estimate_cost) as