1 2 3 4
|
SELECT LS1A_CLIENT.C_CLIENT AS 2, LS1A_ENGAGEMENT.NUM_ENGAGEMENT AS 3, "" AS 73, "" AS 104, "1" AS 120, Left([D_DEB_ENGAG],10) AS 50000, Left([D_DEB_PERIODE],10) AS 50001, Left([D_FIN_PERIODE],10) AS 50002, Left([D_FACTU_PREVUE],10) AS 50003, Left([D_FIN_ENGAG],10) AS 50004, Trim([C_PERIOD_FACTURATION]) AS 50005, LS1A_ENGAGEMENT.C_TYP_FACTURATION AS 50006, LS1A_ACTIVITE.C_ID_ACTIVITE AS 50007, "" AS 50008, "" AS 50009, "2010" AS 50010, "" AS 50011
FROM ((LS1A_ACTIVITE INNER JOIN LS1A_ENGAGEMENT ON LS1A_ACTIVITE.C_ID_ACTIVITE = LS1A_ENGAGEMENT.C_ID_ACTIVITE) INNER JOIN LS1A_CLIENT ON LS1A_ENGAGEMENT.C_ID_CLIENT = LS1A_CLIENT.C_ID_CLIENT) LEFT JOIN LS1A_ECHEANCE ON LS1A_ENGAGEMENT.C_ID_ENGAG = LS1A_ECHEANCE.C_ID_ENGAG
ORDER BY LS1A_ENGAGEMENT.NUM_ENGAGEMENT; |
Partager