1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
|
(SELECT boolLivre*30 FROM(
SELECT COUNT(*) as boolLivre
FROM Item as i, Emprunt as e,Oeuvre as o, Livre as l
WHERE i.oeuvreitem=o.idoeuvre
AND e.item=i.codebarre
AND e.etat='reserve'
AND i.codebarre='3000018'
AND l.oeuvrelivre=o.idoeuvre
) as jrslivre)
,
(SELECT boolDvd*8 FROM(
SELECT COUNT(*) as boolDvd
FROM Item as i, Emprunt as e,Oeuvre as o, DVD as d
WHERE i.oeuvreitem=o.idoeuvre
AND e.item=i.codebarre
AND e.etat='reserve'
AND i.codebarre='3000018'
AND d.oeuvredvd=o.idoeuvre
) as jrsDVD)
,
(SELECT boolCd*15 FROM(
SELECT COUNT(*) as boolCd
FROM Item as i, Emprunt as e,Oeuvre as o, CdAudio as c
WHERE i.oeuvreitem=o.idoeuvre
AND e.item=i.codebarre
AND e.etat='reserve'
AND i.codebarre='3000018'
AND c.oeuvrecdaudio=o.idoeuvre
) as jrsCd)
; |
Partager