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
| select T.tiresbouchesmillesimes_code, requeteun.mise, requetedeux.sortie, requetetrois.commande
from
(select t.tiresbouchesmillesimes_code, sum (miseenbouteille_nombredecols) as mise
from miseenbouteille meb, formatbouteille fb, famillevin fv, millesime m, tiresbouchesmillesimes t
where m.millesime_annee = t.millesime_annee
and fv.famillevin_code = t.famillevin_code
and fb.formatbouteille_code = t.formatbouteille_code
and t.tiresbouchesmillesimes_code = meb.tiresbouchesmillesimes_code
group by t.tiresbouchesmillesimes_code) as requeteun,
(select t.tiresbouchesmillesimes_code , sum (sortiediversetb_nombredecols) as sortie
from sortiediversetb meb, formatbouteille fb, famillevin fv, millesime m, tiresbouchesmillesimes t
where m.millesime_annee = t.millesime_annee
and fv.famillevin_code = t.famillevin_code
and fb.formatbouteille_code = t.formatbouteille_code
and t.tiresbouchesmillesimes_code = meb.tiresbouchesmillesimes_code
group by t.tiresbouchesmillesimes_code) as requetedeux,
(select t.tiresbouchesmillesimes_code , sum (lotcommandé_quantite) as commande
from lotcommandé lc, lot l, formatbouteille fb, famillevin fv, millesime m, tiresbouchesmillesimes t
where m.millesime_annee = t.millesime_annee
and fv.famillevin_code = t.famillevin_code
and fb.formatbouteille_code = t.formatbouteille_code
and t.tiresbouchesmillesimes_code = l.tiresbouchesmillesimes_code
and lc.lot_code = l.lot_code
group by t.tiresbouchesmillesimes_code) as requetetrois ,tiresbouchesmillesimes t
where requetedeux.tiresbouchesmillesimes_code = requeteun.tiresbouchesmillesimes_code
and requetetrois.tiresbouchesmillesimes_code = requetedeux.tiresbouchesmillesimes_code
and requeteun.tiresbouchesmillesimes_code = requetetrois.tiresbouchesmillesimes_code
and t.tiresbouchesmillesimes_code = requeteun.tiresbouchesmillesimes_code |
Partager