SELECT Project.ProjectName AS 'Project Name', cost.CostCategory1 AS 'Cost category1', cost.CostCategory2 AS 'Cost category2' FROM Project INNER JOIN ProjectCost ON Project.projectID = ProjectCost.projectID
Ha egy projektnek több költsége is lehet, akkor.... SELECT Project.ProjectName AS 'Project Name', SUM(cost.CostCategory1) AS 'Cost category1', SUM(cost.CostCategory2) AS 'Cost category2' FROM Project INNER JOIN ProjectCost ON Project.projectID = ProjectCost.projectID GROUP BY Project.ProjectName
