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 37 38
|
requête SQL: Documentation
-- --------------------------------------------------------
--
-- Structure de la table `archive_infos`
--
CREATE ALGORITHM = UNDEFINED DEFINER = `root`@`localhost` SQL SECURITY DEFINER VIEW `gestion-soft`.`archive_infos` AS SELECT `c`.`numc` AS `numc` , `c`.`qteeffect` AS `qteeffect` , `c`.`date` AS `date` , `c`.`dateliv` AS `dateliv` , `c`.`version` AS `version` , `c`.`noms` AS `noms` , `c`.`os` AS `os` , `c`.`numU` AS `numu` , `c`.`nomU` AS `nomu` , `c`.`numDemandeur` AS `numDemandeur` , `c`.`nomDemandeur` AS `nomDemandeur` , `c`.`numL` AS `numl` , `c`.`nomL` AS `noml` , `f`.`numF` AS `numf` , `f`.`nomF` AS `nomf` , `d`.`prix` AS `prix` , (
`c`.`qteeffect` - sum( `p`.`nombre` )
) AS `reste`
FROM (
(
(
`gestion-soft`.`commande_infos` `c`
JOIN `gestion-soft`.`possede_all` `p`
)
JOIN `gestion-soft`.`devis` `d`
)
JOIN `gestion-soft`.`fournisseur` `f`
)
WHERE (
(
`d`.`numC` = `c`.`numc`
)
AND (
`p`.`numc` = `c`.`numc`
)
AND (
`d`.`numF` = `f`.`numF`
)
AND (
`d`.`choisi` = _utf8 '1'
)
)
GROUP BY `p`.`numc` ;
MySQL a répondu:Documentation
#1146 - Table 'gestion-soft.commande_infos' doesn't exist |
Partager