Interogarea originala este:
SELECT
C.numeComponenta,
R.gramaj,
D.pretComponentaPerKg
FROM pizza AS P,
reteta AS R,
componente AS C,
CostComponente AS D
WHERE
P.idPizza=R.idPizza
And r.idcomponenta=c.idcomponenta
And C.idComponenta=D.idComponenta
and p.tippizza='capriciosa';
Un posibil raspuns este:
SELECT
C.numeComponenta,
R.gramaj,
D.pretComponentaPerKg,
(R.gramaj * D.pretComponentaPerKg)/1000 AS Price
FROM pizza AS P,
reteta AS R,
componente AS C,
CostComponente AS D
WHERE
P.idPizza=R.idPizza
And r.idcomponenta=c.idcomponenta
And C.idComponenta=D.idComponenta
and p.tippizza='capriciosa';
Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro