1 2
| SELECT TB_MOUVEMENTS.pk_mouvement, TB_MOUVEMENTS.date_mouvement, TB_MOUVEMENTS.numero_mouvement, TB_DETAILS.fk_description, TB_MOUVEMENTS.fk_departement_provenance, TB_DETAILS.fk_of, TB_ASSO_OF.pk_fk_alliage_of, TB_ALLIAGES_1.titre_Au, TB_ALLIAGES_1.titre_Ag, TB_ALLIAGES_1.titre_Pd, TB_ALLIAGES_1.titre_Pt, TB_DETAILS.fk_lingot, TB_ASSO_LINGOT.pk_fk_alliage_lingot, TB_ALLIAGES.titre_Au, TB_ALLIAGES.titre_Ag, TB_ALLIAGES.titre_Pd, TB_ALLIAGES.titre_Pt, TB_DEPARTEMENTS.pk_departement, TB_DESTINATIONS.quittancer_mouvement
FROM (TB_OFS LEFT JOIN (TB_ALLIAGES AS TB_ALLIAGES_1 RIGHT JOIN TB_ASSO_OF ON TB_ALLIAGES_1.pk_alliage = TB_ASSO_OF.pk_fk_alliage_of) ON TB_OFS.pk_of = TB_ASSO_OF.pk_fk_of) RIGHT JOIN ((TB_MOUVEMENTS INNER JOIN (TB_DEPARTEMENTS INNER JOIN TB_DESTINATIONS ON TB_DEPARTEMENTS.pk_departement = TB_DESTINATIONS.pk_fk_departement_destination) ON TB_MOUVEMENTS.pk_mouvement = TB_DESTINATIONS.pk_fk_mouvement_destination) INNER JOIN ((TB_LINGOTS INNER JOIN (TB_ALLIAGES INNER JOIN TB_ASSO_LINGOT ON TB_ALLIAGES.pk_alliage = TB_ASSO_LINGOT.pk_fk_alliage_lingot) ON TB_LINGOTS.pk_lingot = TB_ASSO_LINGOT.pk_fk_lingot) INNER JOIN TB_DETAILS ON TB_LINGOTS.pk_lingot = TB_DETAILS.fk_lingot) ON TB_MOUVEMENTS.pk_mouvement = TB_DETAILS.fk_mouvement) ON TB_OFS.pk_of = TB_DETAILS.fk_of; |
Partager