1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
|
INSERT INTO facture(idcat,catclient_libelle,cin,nom,prenom,remise,catvehicule_idcat,vehicule_idmat,marque,serie,prix,date,nbr_jr,total) VALUES(SELECT cat_client.id_cat, cat_client.libelle, client.cin, client.nom, client.prenom, cat_client.remise, cat_vehicule.id_cat, vehicule.id_mat, vehicule.marque, vehicule.serie, cat_vehicule.prix AS prixUnitaire, reservation.date_res,reservation.nbr_jr ,(
(
cat_vehicule.prix * reservation.nbr_jr
) - ( (
cat_client.remise /100
) * cat_vehicule.prix * reservation.nbr_jr )
) AS prix_totale
FROM cat_client, client, cat_vehicule, vehicule, reservation
WHERE cat_client.id_cat = client.id_cat
AND client.cin = reservation.cin
AND cat_vehicule.id_cat = vehicule.id_cat
AND vehicule.id_mat = reservation.id_mat
AND id_res =3) |
Partager