1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| INSERT INTO F_EcritureC ( JO_Num, EC_No, EC_NoLink, JM_Date, EC_Jour, EC_Date, EC_Piece,
CG_Num, CG_NumCont, CT_Num, EC_Intitule,
EC_Echeance, N_Devise, EC_Sens, EC_Montant,
EC_Lettre, EC_Lettrage, CT_NumCont,
EC_Devise, cbMarq )
SELECT F_EcritureC.JO_Num, F_EcritureC.EC_No,
F_EcritureC.EC_NoLink, F_EcritureC.JM_Date,
F_EcritureC.EC_Jour, F_EcritureC.EC_Date,
F_EcritureC.EC_Piece, F_EcritureC.CG_Num,
F_EcritureC.CG_NumCont, F_EcritureC.CT_Num,
F_EcritureC.EC_Intitule, F_EcritureC.EC_Echeance,
F_EcritureC.N_Devise, F_EcritureC.EC_Sens,
F_EcritureC.EC_Montant, F_EcritureC.EC_Lettre,
F_EcritureC.EC_Lettrage, F_EcritureC.CT_NumCont,
F_EcritureC.EC_Devise, F_EcritureC.cbMarq"
FROM NOMDEL'entreprise , F_EcritureC
LEFT JOIN F_CompteT ON F_EcritureC.CT_Num = F_CompteT.CT_Num"
WHERE (((F_EcritureC.JM_Date)>#12/31/2007#)
AND ((F_EcritureC.CG_Num)='411000'
Or (F_EcritureC.CG_Num)='413000')
AND ((F_EcritureC.EC_Lettre)=0)
AND ((F_CompteT.Factor)='EUROFACTOR FRANCE')); |
Partager