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 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65
| SELECT OLSTOK00.STARTI Article,
OLSTOK00.STDEPV Marche,
(SELECT OLARTI00.ARCDCL FROM OLYMP_D/OLARTI00 WHERE OLSTOK00.STARTI=OLARTI00.ARARTI AND OLARTI00.ARSOCI='09') Statut,
OLSTOK00.STDES1 Designation,
(SELECT OLARTI00.ARDES2 Designation_2 FROM OLYMP_D/OLARTI00 WHERE OLARTI00.ARARTI=OLSTOK00.STARTI AND OLARTI00.ARSOCI='09') Designation2,
(SELECT OLFOUR10.FORAIS FROM OLYMP_D/OLFOUR10 WHERE OLFOUR10.FOFORS=(SELECT OLARTI00.ARFOUR FROM OLYMP_D/OLARTI00 WHERE OLARTI00.ARFORP=OLSTOK00.STFOUR AND OLARTI00.ARSOCI='09' AND OLARTI00.ARARTI=OLSTOK00.STARTI) AND OLFOUR10.FOSOCI='09' AND OLFOUR10.FOFFAM='MAT') Fournisseur,
(SELECT OLAFOU00.AFARFO FROM OLYMP_D/OLAFOU00 WHERE OLAFOU00.AFARTI=OLSTOK00.STARTI AND OLAFOU00.AFFOUR=OLSTOK00.STFOUR AND OLAFOU00.AFSOCI='09') Ref_Fournisseur,
OLSTOK00.STCMUP CMUP,
OLSTOK00.STTHEO Theorique,
pseudo.STTHEO nutin,
OLSTOK00.STENCC Enc_Clients,
OLSTOK00.STDISP Dispo,
OLSTOK00.STRESE Reliquats,
OLSTOK00.STENFO Enc_Frs,
OLSTOK00.STTHEO-(OLSTOK00.STENCC+OLSTOK00.STRESE) Stock,
(OLSTOK00.STTHEO-(OLSTOK00.STENCC+OLSTOK00.STRESE))+OLSTOK00.STENFO Stock_plus_frs,
(SELECT OLSCAN00.SCA001 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Janvier_2013,
(SELECT OLSCAN00.SCA002 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Fevrier_2013,
(SELECT OLSCAN00.SCA003 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Mars_2013,
(SELECT OLSCAN00.SCA004 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Avril_2013,
(SELECT OLSCAN00.SCA005 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Mai_2013,
(SELECT OLSCAN00.SCA006 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Juin_2013,
(SELECT OLSCAN00.SCA007 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Juillet_2013,
(SELECT OLSCAN00.SCA008 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Aout_2013,
(SELECT OLSCAN00.SCA009 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Septembre_2013,
(SELECT OLSCAN00.SCA010 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Octobre_2013,
(SELECT OLSCAN00.SCA011 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Novembre_2013,
(SELECT OLSCAN00.SCA012 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Decembre_2013,
(SELECT OLSCAN00.SCA001 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Janvier,
(SELECT OLSCAN00.SCA002 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Fevrier,
(SELECT OLSCAN00.SCA003 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Mars,
(SELECT OLSCAN00.SCA004 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Avril,
(SELECT OLSCAN00.SCA005 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Mai,
(SELECT OLSCAN00.SCA006 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Juin,
(SELECT OLSCAN00.SCA007 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Juillet,
(SELECT OLSCAN00.SCA008 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Aout,
(SELECT OLSCAN00.SCA009 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Septembre,
(SELECT OLSCAN00.SCA010 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Octobre,
(SELECT OLSCAN00.SCA011 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Novembre,
(SELECT OLSCAN00.SCA012 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) Decembre,
(SELECT OLSCAN00.SCA001 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA002 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA003 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA004 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA005 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA006 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA007 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA008 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA009 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA010 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA011 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA012 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2013' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) somme_2013,
(SELECT OLSCAN00.SCA001 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA002 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA003 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA004 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA005 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA006 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA007 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA008 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA009 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA010 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA011 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI)+
(SELECT OLSCAN00.SCA012 FROM OLYMP_STOD/OLSCAN00 WHERE OLSCAN00.SCSOCI='09' AND OLSCAN00.SCDEPO='SK1' AND OLSCAN00.SCANNE='2014' AND OLSTOK00.STARTI=OLSCAN00.SCARTI) somme_2014
FROM OLYMP_STOD/OLSTOK00 LEFT JOIN OLYMP_STOD/OLSTOK00 pseudo on OLSTOK00.STARTI=pseudo.STARTI AND pseudo.STDEPO='NUT' WHERE OLSTOK00.STSOCI='09' AND OLSTOK00.STDEPO='SK1' |
Partager