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, September 16, 2014 6:12 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] Re: SubQuery Help I'd recommend using a left join with table alias. Example Select a.Project_PK , SUM(b.cost) AS Sum_of_Cost , SUM(b.estimate_cost) AS Sum_of_Estimated_Cost , SUM(c.quantity) AS Sum_of_Quantity , SUM(c.estimate_quantity) AS Sum_of_Estimated_Quantity FROM Projects a LEFT JOIN Cost b ON a.project_pk = b.project_pk LEFT JOIN Quantity c ON a.project_pk = c.project_pk -- Dixon Epperson
