Auf Thema antworten

Beitrag

Der letzte Join is Murks (m:m zwischen projects und cost centers) ... ich meinte so:

SELECT sum(costs)
FROM costs&resources c&r
JOIN projects/cost centers p/cc
ON c&r.FK_cost centers = p/cc.FK_cost centers
WHRE FK_projects =
(
SELECT ID_Projects
FROM projects
WHERE project_name = 'X'
)

[QUOTE="Säsch, post: 15693, member: 2244"] Der letzte Join is Murks (m:m zwischen projects und cost centers) ... ich meinte so: SELECT sum(costs) FROM costs&resources c&r JOIN projects/cost centers p/cc ON c&r.FK_cost centers = p/cc.FK_cost centers WHRE FK_projects = ( SELECT ID_Projects FROM projects WHERE project_name = 'X' ) [/QUOTE]

Authentifizierung

Datenbankserver
Datenmodellierung, Datenbank-Design
Entwicklung eines Datenbanksystems