pierrep56
üzgünüm soruyu anlamadım
Ce SQL ne fonctionne pas
Req = "SELECT T1.F7, T1.F8, T1.F9, T1.F10, T1.F11, T1.F12, T1.F13, T1.F14, T1.F15, T1.F16, T1.F17, T1.F18, T1.F19, T1.F20, T1.F21, T1.F22, T1.F23, T1.F24, T1.F25, T1.F26 " & _
" FROM ([" & sht & "$A8:D] AS T0" & _
" LEFT JOIN [" & sht & "$AJ8:BI] AS T1 ON T0.F3=T1.F3)" & _
" WHERE NOT ISNULL(T0.F3)" & _
" ORDER BY T0.F1"
Ce SQL fonctionne
Req = "SELECT T1.F7, T1.F8, T1.F9, T1.F10, T1.F11, T1.F12, T1.F13, T1.F14, T1.F15, T1.F16, T1.F17, T1.F18, T1.F19, T1.F20, T1.F21, T1.F22, T1.F23, T1.F24, T1.F25, T1.F26 " & _
" FROM ([" & sht & "$A8:D] AS T0" & _
" LEFT JOIN [" & sht & "$AJ8:BI] AS T1 ON T0.F3=T1.F3)" & _
" WHERE NOT ISNULL(T0.F3)"
La différence entre les deux
" & _
" ORDER BY T0.F1"