Discussion :

[misscricri]

Bonjour à tous!

j'ai un problème avec ma requête, j'aimerais ne pas avoir de doublons:

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
 
select distinct		
		[premieraviation].[dbo].[ictwhs].[ctype],
		[premieraviation].[dbo].[ictwhs].[cwarehouse],
		[premieraviation].[dbo].[ictwhs].[cdescript], 
		[premieraviation].[dbo].[ictwhs].[crevncode],
		[premieraviation].[dbo].[ictwhs].[cinvtacc],
		[premieraviation].[dbo].[ictwhs].[cintracc]
 
 from 
 
[premieraviation].[dbo].[ictwhs] 
 
inner join [premieraviation].[dbo].[ictype] on 
 
[premieraviation].[dbo].[ictwhs].ctype = [premieraviation].[dbo].[ictype].ctype
 
inner join [premieraviation].[dbo].[icwhse] on 
 
[premieraviation].[dbo].[ictwhs].cdescript = [premieraviation].[dbo].[icwhse].cdescript
 
nner join [premieraviation].[dbo].[arrevn] on 
 
[premieraviation].[dbo].[ictwhs].crevncode = [premieraviation].[dbo].[arrevn].crevncode

et voici le resultat :

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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
 
COMPOSITE 	_EQUIP    	Entretien équipement               	PCES_EQUIP	56205-0-0000-0-0000000        	56205-0-0000-0-0000000        
COMPOSITE 	_HANGAR   	Entretien hangar                   	PCES_HAN  	56210-0-0000-0-0000000        	56210-0-0000-0-0000000        
COMPOSITE 	_PREMIER  	Dépenses générales PA              	PCES_FGEN 	56999-0-0000-0-0000000        	56999-0-0000-0-0000000        
COMPOSITE 	AVION     	Ventes projet avion                	E_MET&COMP	11100-0-0000-0-0000000        	11100-0-0000-0-0000000        
COMPOSITE 	CAA       	ALOHA AIRLINES                     	E_MET&COMP	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
COMPOSITE 	CAC       	AIR CANADA                         	E_MET&COMP	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
COMPOSITE 	CACJ      	AIR CANADA JAZZ                    	E_MET&COMP	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
COMPOSITE 	CAN       	AIR NORTH                          	E_MET&COMP	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
COMPOSITE 	CAVO      	AVEO                               	E_MET&COMP	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
COMPOSITE 	CBA       	BOMBARDIER AEROSPACE               	E_MET&COMP	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
COMPOSITE 	CCJ       	CARGOJET AIRLINES                  	E_MET&COMP	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
COMPOSITE 	CCNJ      	CANJET                             	E_MET&COMP	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
COMPOSITE 	CHT       	HÉLI-TRANSPORT                     	E_MET&COMP	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
COMPOSITE 	CLM       	CALM AIR                           	E_MET&COMP	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
COMPOSITE 	CNA       	NOLINOR AVIATION                   	E_MET&COMP	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
COMPOSITE 	CPS       	PACIFIC SKY                        	E_MET&COMP	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
COMPOSITE 	CPW       	PRATT & WHITNEY                    	E_MET&COMP	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
COMPOSITE 	CSW       	SUNWING AIRLINES INC               	E_MET&COMP	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
COMPOSITE 	ECOLE     	Ventes école                       	AUT_PCES  	50480-0-0000-0-0000000        	50480-0-0000-0-0000000        
COMPOSITE 	MAIN      	Main                               	E_MET&COMP	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
COMPOSITE 	OPS       	Premier Aviation Ottawa            	E_MET&COMP	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
COMPOSITE 	QPS       	Premier Aviation Québec            	E_MET&COMP	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
COMPOSITE 	SALES     	TRANSIT (VENTES)                   	AUT_PCES  	50480-0-0000-0-0000000        	50480-0-0000-0-0000000        
COMPOSITE 	TPA       	Avionic                            	E_MET&COMP	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
COMPOSITE 	TPB       	Bureautique                        	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
COMPOSITE 	TPCO      	Composite                          	E_MET&COMP	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
COMPOSITE 	TPM       	Metal                              	E_MET&COMP	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
COMPOSITE 	TPMC      	Machining shop                     	E_MET&COMP	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
COMPOSITE 	TPOH      	Hangar 100 X 110                   	E_MET&COMP	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
COMPOSITE 	TPOL1     	Petrol-Oil-Liquid                  	E_MET&COMP	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
COMPOSITE 	TPOS      	Overstock Premier Aviation         	E_MET&COMP	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
COMPOSITE 	TPQ       	Quarantaine                        	E_MET&COMP	14010-0-0000-0-0000000        	14010-0-0000-0-0000000        
COMPOSITE 	TPS       	Store                              	E_MET&COMP	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
COMPOSITE 	TPT       	Tooling                            	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
COMPOSITE 	TPV       	Vêtements                          	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
COMPOSITE 	TRANSITEXT	EXTERNAL TRANSIT (OUTSIDE PREMIER) 	E_MET&COMP	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
ENT/REP PA	_EQUIP    	Entretien équipement               	AREV_EQUIP	56205-0-0000-0-0000000        	56205-0-0000-0-0000000        
ENT/REP PA	_HANGAR   	Entretien hangar                   	AREV_HAN  	56210-0-0000-0-0000000        	56210-0-0000-0-0000000        
ENT/REP PA	_PREMIER  	Dépenses générales PA              	AREV_FGEN 	56999-0-0000-0-0000000        	56999-0-0000-0-0000000        
ENT/REP PA	CAA       	ALOHA AIRLINES                     	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	CAC       	AIR CANADA                         	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	CACJ      	AIR CANADA JAZZ                    	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	CAN       	AIR NORTH                          	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	CAVO      	AVEO                               	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	CBA       	BOMBARDIER AEROSPACE               	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	CCJ       	CARGOJET AIRLINES                  	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	CCN       	CANADIAN NORTH                     	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	CCNJ      	CANJET                             	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	CF        	FIRST AIR                          	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	CHT       	HÉLI-TRANSPORT                     	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	CLM       	CALM AIR                           	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	CNA       	NOLINOR AVIATION                   	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	CPS       	PACIFIC SKY                        	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	CPW       	PRATT & WHITNEY                    	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	CSW       	SUNWING AIRLINES INC               	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	CW        	WESTJET                            	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	ECOLE     	Ventes école                       	AUT_PCES  	50480-0-0000-0-0000000        	50480-0-0000-0-0000000        
ENT/REP PA	MAIN      	Main                               	G_BATGEN  	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
ENT/REP PA	OPS       	Premier Aviation Ottawa            	G_BATGEN  	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
ENT/REP PA	QPS       	Premier Aviation Québec            	G_BATGEN  	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
ENT/REP PA	SALES     	TRANSIT (VENTES)                   	AUT_PCES  	50480-0-0000-0-0000000        	50480-0-0000-0-0000000        
ENT/REP PA	TPA       	Avionic                            	G_BATGEN  	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
ENT/REP PA	TPB       	Bureautique                        	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	TPCO      	Composite                          	G_BATGEN  	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
ENT/REP PA	TPM       	Metal                              	G_BATGEN  	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
ENT/REP PA	TPMC      	Machining shop                     	G_BATGEN  	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
ENT/REP PA	TPOH      	Hangar 100 X 110                   	G_BATGEN  	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
ENT/REP PA	TPOL1     	Petrol-Oil-Liquid                  	G_BATGEN  	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
ENT/REP PA	TPOS      	Overstock Premier Aviation         	G_BATGEN  	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
ENT/REP PA	TPQ       	Quarantaine                        	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	TPS       	Store                              	G_BATGEN  	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
ENT/REP PA	TPT       	Tooling                            	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	TPV       	Vêtements                          	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
ENT/REP PA	TRANSITEXT	EXTERNAL TRANSIT (OUTSIDE PREMIER) 	G_BATGEN  	14000-0-0000-0-0000000        	14000-0-0000-0-0000000        
EQUIPEMENT	_EQUIP    	Entretien équipement               	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	_HANGAR   	Entretien hangar                   	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	_PREMIER  	Dépenses générales PA              	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	CAA       	ALOHA AIRLINES                     	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	CAC       	AIR CANADA                         	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	CACJ      	AIR CANADA JAZZ                    	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	CAN       	AIR NORTH                          	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	CAVO      	AVEO                               	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	CBA       	BOMBARDIER AEROSPACE               	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	CCJ       	CARGOJET AIRLINES                  	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	CCNJ      	CANJET                             	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	CHT       	HÉLI-TRANSPORT                     	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	CLM       	CALM AIR                           	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	CNA       	NOLINOR AVIATION                   	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	CPS       	PACIFIC SKY                        	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	CPW       	PRATT & WHITNEY                    	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	CSW       	SUNWING AIRLINES INC               	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	ECOLE     	Ventes école                       	G_EQ500+  	16200-0-0000-0-0000000        	16200-0-0000-0-0000000        
EQUIPEMENT	MAIN      	Main                               	G_EQ500+  	16200-0-0000-0-0000000        	16200-0-0000-0-0000000        
EQUIPEMENT	OPS       	Premier Aviation Ottawa            	G_EQ500+  	16200-0-0000-0-0000000        	16200-0-0000-0-0000000        
EQUIPEMENT	QPS       	Premier Aviation Québec            	G_EQ500+  	16200-0-0000-0-0000000        	16200-0-0000-0-0000000        
EQUIPEMENT	SALES     	TRANSIT (VENTES)                   	G_EQ500+  	16200-0-0000-0-0000000        	16200-0-0000-0-0000000        
EQUIPEMENT	TPA       	Avionic                            	G_EQ500+  	16200-0-0000-0-0000000        	16200-0-0000-0-0000000        
EQUIPEMENT	TPB       	Bureautique                        	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	TPCO      	Composite                          	G_EQ500+  	16200-0-0000-0-0000000        	16200-0-0000-0-0000000        
EQUIPEMENT	TPM       	Metal                              	G_EQ500+  	16200-0-0000-0-0000000        	16200-0-0000-0-0000000        
EQUIPEMENT	TPMC      	Machining shop                     	G_EQ500+  	16200-0-0000-0-0000000        	16200-0-0000-0-0000000        
EQUIPEMENT	TPOH      	Hangar 100 X 110                   	G_EQ500+  	16200-0-0000-0-0000000        	16200-0-0000-0-0000000        
EQUIPEMENT	TPOL1     	Petrol-Oil-Liquid                  	G_EQ500+  	16200-0-0000-0-0000000        	16200-0-0000-0-0000000        
EQUIPEMENT	TPOS      	Overstock Premier Aviation         	G_EQ500+  	16200-0-0000-0-0000000        	16200-0-0000-0-0000000        
EQUIPEMENT	TPQ       	Quarantaine                        	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	TPS       	Store                              	G_EQ500+  	16200-0-0000-0-0000000        	16200-0-0000-0-0000000        
EQUIPEMENT	TPT       	Tooling                            	G_EQ500+  	16200-0-0000-0-0000000        	16200-0-0000-0-0000000        
EQUIPEMENT	TPV       	Vêtements                          	PREMIER   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000        
EQUIPEMENT	TRANSITEXT	EXTERNAL TRANSIT (OUTSIDE PREMIER) 	G_EQ500+  	16200-0-0000-0-0000000        CCJ       	CARGOJET AIRLINES                  	E_PARTS   	99999-0-0000-0-0000000        	99999-0-0000-0-0000000