Bonjour à tous,

J'ai un souci avec une requête. En effet j'ai un champ identique OLSTOK00.STTHEO que je souhaite renvoyer sous deux colonnes, avec une fonction WHERE différente, la première condition étant OLSTOK00.STDEPO='SK1' et la deuxième étant OLSTOK00.STDEPO='NUT'.
Je sais qu'en faisant avec OR ça fonctionne, mais ça me renvoi les valeurs sous forme de ligne supplémentaire, alors que je souhaite avoir ces deux valeurs sous forme de colonne. J'ai essayé un SELECT imbriqué, mais sans succès.
Quelqu'un pour m'aider ?

Code : Sélectionner tout - Visualiser dans une fenêtre à part
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, 
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 WHERE OLSTOK00.STSOCI='09' and OLSTOK00.STDEPO='SK1'