Advertisement
Guest User

Untitled

a guest
Jun 25th, 2017
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. select sum(t.prix * a.nb_prest)
  2. from PRESTATION p , TARIF t , ACHAT a , TICKET ti , USAGER u
  3. where type_prest="supplement chantilly"
  4. and p.num_prest=t.num_prest
  5. and t.num_prest=a.num_prest
  6. and a.num_ticket=ti.num_ticket
  7. and ti.num_carte =u.num_carte
  8. and u.num_categ=t.num_categ
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement