Problème fusion de deux requêtes

**Chloooé** · 09/12/2018, 13h49

Bonjour à tous,

Je sollicite votre aide car je suis bloquée sur une requête sans savoir pourquoi celle-ci ne fonctionne pas.

Résultat première requête (SQLClientsRégions) :

NombreClients	TerritoiresVentes	Pays
3631	Australia	Australia
1685	Canada	Canada
1850	France	France
1820	Germany	Germany
1953	United Kingdom	United Kingdom
71	Central	United States
64	Northeast	United States
3433	Northwest	United States
97	Southeast	United States
4581	Southwest	United States

Programmation SQL première requête (SQLClientsRégions) :

Code SQL :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
SELECT count(customer.customerid) AS NombreClients, SalesTerritory.Name AS TerritoiresVentes, CountryRegion.Name AS Pays
FROM customer, salesterritory, countryregion
WHERE customer.territoryid = salesterritory.territoryid
and countryregion.countryregioncode = salesterritory.countryregioncode
GROUP BY CountryRegion.Name, salesterritory.name;

Résultat deuxième requête (SQLCommerciauxRégions) :

NombreCommerciaux	TerritoiresVentes	Pays
1	Australia	Australia
2	Canada	Canada
1	France	France
1	Germany	Germany
1	United Kingdom	United Kingdom
1	Central	United States
1	Northeast	United States
3	Northwest	United States
1	Southeast	United States
2	Southwest	United States

Programmation SQL deuxième requête (SQLCommerciauxRégions) :

Code SQL :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
SELECT count(salesperson.salespersonid) AS NombreCommerciaux, SalesTerritory.Name AS TerritoiresVentes, CountryRegion.Name AS Pays
FROM salesperson, salesterritory, countryregion
WHERE salesperson.territoryid = salesterritory.territoryid
and countryregion.countryregioncode = salesterritory.countryregioncode
GROUP BY CountryRegion.Name, salesterritory.name;

Jusqu'ici tout va bien …

Le problème est la troisième requête que j'ai fait …

Programmation SQL troisième requête (SQLCouvertureMarché) :

Code SQL :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
SELECT NombreClients/NombreCommerciaux as ClientsParCommercial, SQLClientsRégions.TerritoiresVentes, SQLClientsRégions.Pays
from SQLCommerciauxrégions, SQLClientsRégions
where sqlclientsrégions.territoiresventes = sqlcommerciauxrégions.territoiresventes
and sqlclientsrégions.pays = sqlcommerciauxrégions.pays ;

Résultat troisième requête (SQLCouvertureMarché) :

ClientsParCommercial	TerritoiresVentes	Pays
3631	Australia	Australia
842,5	Canada	Canada
1850	France	France
1820	Germany	Germany
1953	United Kingdom	United Kingdom

J'ai beau prendre le problème dans tous les sens, je ne comprends pas pourquoi il ne veut pas prendre en compte les dernières lignes relatives aux United States.
Merci pour votre aide ...
Bonne journée !

**james68** · 10/12/2018, 09h59

N'ayant pas les tables de bases j'ai créé 2 tables avec les résultats de tes deux premières requêtes puis j'ai lancé la dernière requête.
le résultat est correct.

ClientsParCommercial	TerritoiresVentes	Pays
3631	Australia	Australia
842,5	Canada	Canada
1850	France	France
1820	Germany	Germany
1953	United Kingdom	United Kingdom
71	Central	United States
64	Northeast	United States
1144,33333333333	Northwest	United States
97	Southeast	United States
2290,5	Southwest	United States

le problème doit plutôt venir de tes datas ( orphelin , valeur nulle etc... ), voire de tes deux premières requêtes.
Bon courage
;-)

**Chloooé** · 10/12/2018, 10h10

Merci James68 pour votre réponse.

Malheureusement je ne trouve pas d'où peut venir le problème … Vous sembliez dire que cela peut venir d'un type de données valeur nulle ? Est-ce que vous pourriez m'en dire un peu plus ?

Passez une bonne journée et merci encore.

**james68** · 10/12/2018, 10h52

Salut,
t'est il possible de m'envoyer les tables sources ?

**Chloooé** · 10/12/2018, 12h16

Table Salesperson

SalesPersonID	TerritoryID	SalesQuota	Bonus	CommissionPct	SalesYTD	SalesLastYear	rowguid	ModifiedDate
268	999		0,00 €	0,00 €	677 558,47 €	0,00 €	{48754992-9EE0-4C0E-8C94-9451604E3E02}	28/01/2001
275	2	300 000,00 €	4 100,00 €	0,01 €	4 557 045,05 €	1 750 406,48 €	{1E0A7274-3064-4F58-88EE-4C6586C87169}	24/06/2001
276	4	250 000,00 €	2 000,00 €	0,02 €	5 200 475,23 €	1 439 156,03 €	{4DD9EEE4-8E81-4F8C-AF97-683394C1F7C0}	24/06/2001
277	3	250 000,00 €	2 500,00 €	0,02 €	3 857 163,63 €	1 997 186,20 €	{39012928-BFEC-4242-874D-423162C3F567}	24/06/2001
278	6	250 000,00 €	500,00 €	0,01 €	1 764 938,99 €	1 620 276,90 €	{7A0AE1AB-B283-40F9-91D1-167ABF06D720}	24/06/2001
279	5	300 000,00 €	6 700,00 €	0,01 €	2 811 012,72 €	1 849 640,94 €	{52A5179D-3239-4157-AE29-17E868296DC0}	24/06/2001
280	1	250 000,00 €	5 000,00 €	0,01 €	0,00 €	1 927 059,18 €	{BE941A4A-FB50-4947-BDA4-BB8972365B08}	24/06/2001
281	4	250 000,00 €	3 550,00 €	0,01 €	3 018 725,49 €	2 073 506,00 €	{35326DDB-7278-4FEF-B3BA-EA137B69094E}	24/06/2001
282	6	250 000,00 €	5 000,00 €	0,02 €	3 189 356,25 €	2 038 234,65 €	{31FD7FC1-DC84-4F05-B9A0-762519EACACC}	24/06/2001
283	1	250 000,00 €	3 500,00 €	0,01 €	3 587 378,43 €	1 371 635,32 €	{6BAC15B2-8FFB-45A9-B6D5-040E16C2073F}	24/06/2001
284	999		0,00 €	0,00 €	636 440,25 €	0,00 €	{1DD1F689-DF74-4149-8600-59555EEF154B}	11/05/2002
285	10	250 000,00 €	5 150,00 €	0,02 €	5 015 682,38 €	1 635 823,40 €	{25F6838D-9DB4-4833-9DDC-7A24283AF1BA}	24/06/2002
286	7	250 000,00 €	985,00 €	0,02 €	3 827 950,24 €	2 396 539,76 €	{F509E3D4-76C8-42AA-B353-90B7B8DB08DE}	24/06/2002
287	1	300 000,00 €	3 900,00 €	0,02 €	1 931 620,18 €	0,00 €	{AC94EC04-A2DC-43E3-8654-DD0C546ABC17}	25/10/2002
288	999		0,00 €	0,00 €	219 088,88 €	0,00 €	{CFDBEF27-B1F7-4A56-A878-0221C73BAE67}	08/04/2003
289	8	250 000,00 €	75,00 €	0,02 €	2 241 204,04 €	1 307 949,79 €	{224BB25A-62E3-493E-ACAF-4F8F5C72396A}	24/06/2003
290	9	250 000,00 €	5 650,00 €	0,02 €	1 758 385,93 €	2 278 548,98 €	{9B968777-75DC-45BD-A8DF-9CDAA72839E1}	24/06/2003

Table Salesterritory

TerritoryID	Name	CountryRegionCode	Group	SalesYTD	SalesLastYear	CostYTD	CostLastYear	rowguid	ModifiedDate
1	Northwest	US	North America	5 767 341,98 €	3 298 694,49 €	0,00 €	0,00 €	{43689A10-E30B-497F-B0DE-11DE20267FF7}	01/06/1998
2	Northeast	US	North America	3 857 163,63 €	3 607 148,94 €	0,00 €	0,00 €	{00FB7309-96CC-49E2-8363-0A1BA72486F2}	01/06/1998
3	Central	US	North America	4 677 108,27 €	3 205 014,08 €	0,00 €	0,00 €	{DF6E7FD8-1A8D-468C-B103-ED8ADDB452C1}	01/06/1998
4	Southwest	US	North America	8 351 296,74 €	5 366 575,71 €	0,00 €	0,00 €	{DC3E9EA0-7950-4431-9428-99DBCBC33865}	01/06/1998
5	Southeast	US	North America	2 851 419,04 €	3 925 071,43 €	0,00 €	0,00 €	{6DC4165A-5E4C-42D2-809D-4344E0AC75E7}	01/06/1998
6	Canada	CA	North America	6 917 270,88 €	5 693 988,86 €	0,00 €	0,00 €	{06B4AF8A-1639-476E-9266-110461D66B00}	01/06/1998
7	France	FR	Europe	3 899 045,69 €	2 396 539,76 €	0,00 €	0,00 €	{BF806804-9B4C-4B07-9D19-706F2E689552}	01/06/1998
8	Germany	DE	Europe	2 481 039,18 €	1 307 949,79 €	0,00 €	0,00 €	{6D2450DB-8159-414F-A917-E73EE91C38A9}	01/06/1998
9	Australia	AU	Pacific	1 977 474,81 €	2 278 548,98 €	0,00 €	0,00 €	{602E612E-DFE9-41D9-B894-27E489747885}	01/06/1998
10	United Kingdom	GB	Europe	3 514 865,91 €	1 635 823,40 €	0,00 €	0,00 €	{05FC7E1F-2DEA-414E-9ECD-09D150516FB5}	01/06/1998
999	Non renseigné

Table Countryregion

CountryRegionCode	Name	ModifiedDate
AD	Andorra	01/06/1998
AE	United Arab Emirates	01/06/1998
AF	Afghanistan	01/06/1998
AG	Antigua and Barbuda	01/06/1998
AI	Anguilla	01/06/1998
AL	Albania	01/06/1998
AM	Armenia	01/06/1998
AN	Netherlands Antilles	01/06/1998
AO	Angola	01/06/1998
AQ	Antarctica	01/06/1998
AR	Argentina	01/06/1998
AS	American Samoa	01/06/1998
AT	Austria	01/06/1998
AU	Australia	01/06/1998
AW	Aruba	01/06/1998
AZ	Azerbaijan	01/06/1998
BA	Bosnia and Herzegovina	01/06/1998
BB	Barbados	01/06/1998
BD	Bangladesh	01/06/1998
BE	Belgium	01/06/1998
BF	Burkina Faso	01/06/1998
BG	Bulgaria	01/06/1998
BH	Bahrain	01/06/1998
BI	Burundi	01/06/1998
BJ	Benin	01/06/1998
BM	Bermuda	01/06/1998
BN	Brunei	01/06/1998
BO	Bolivia	01/06/1998
BR	Brazil	01/06/1998
BS	Bahamas, The	01/06/1998
BT	Bhutan	01/06/1998
BV	Bouvet Island	01/06/1998
BW	Botswana	01/06/1998
BY	Belarus	01/06/1998
BZ	Belize	01/06/1998
CA	Canada	01/06/1998
CC	Cocos (Keeling) Islands	01/06/1998
CD	Congo (DRC)	01/06/1998
CF	Central African Republic	01/06/1998
CG	Congo	01/06/1998
CH	Switzerland	01/06/1998
CI	Côte d'Ivoire	01/06/1998
CK	Cook Islands	01/06/1998
CL	Chile	01/06/1998
CM	Cameroon	01/06/1998
CN	China	01/06/1998
CO	Colombia	01/06/1998
CR	Costa Rica	01/06/1998
CS	Serbia and Montenegro	01/06/1998
CU	Cuba	01/06/1998
CV	Cape Verde	01/06/1998
CX	Christmas Island	01/06/1998
CY	Cyprus	01/06/1998
CZ	Czech Republic	01/06/1998
DE	Germany	01/06/1998
DJ	Djibouti	01/06/1998
DK	Denmark	01/06/1998
DM	Dominica	01/06/1998
DO	Dominican Republic	01/06/1998
DZ	Algeria	01/06/1998
EC	Ecuador	01/06/1998
EE	Estonia	01/06/1998
EG	Egypt	01/06/1998
ER	Eritrea	01/06/1998
ES	Spain	01/06/1998
ET	Ethiopia	01/06/1998
FI	Finland	01/06/1998
FJ	Fiji Islands	01/06/1998
FK	Falkland Islands (Islas Malvinas)	01/06/1998
FM	Micronesia	01/06/1998
FO	Faroe Islands	01/06/1998
FR	France	01/06/1998
GA	Gabon	01/06/1998
GB	United Kingdom	01/06/1998
GD	Grenada	01/06/1998
GE	Georgia	01/06/1998
GF	French Guiana	01/06/1998
GH	Ghana	01/06/1998
GI	Gibraltar	01/06/1998
GL	Greenland	01/06/1998
GM	Gambia, The	01/06/1998
GN	Guinea	01/06/1998
GP	Guadeloupe	01/06/1998
GQ	Equatorial Guinea	01/06/1998
GR	Greece	01/06/1998
GS	South Georgia and the South Sandwich Islands	01/06/1998
GT	Guatemala	01/06/1998
GU	Guam	01/06/1998
GW	Guinea-Bissau	01/06/1998
GY	Guyana	01/06/1998
HK	Hong Kong SAR	01/06/1998
HM	Heard Island and McDonald Islands	01/06/1998
HN	Honduras	01/06/1998
HR	Croatia	01/06/1998
HT	Haiti	01/06/1998
HU	Hungary	01/06/1998
ID	Indonesia	01/06/1998
IE	Ireland	01/06/1998
IL	Israel	01/06/1998
IN	India	01/06/1998
IO	British Indian Ocean Territory	01/06/1998
IQ	Iraq	01/06/1998
IR	Iran	01/06/1998
IS	Iceland	01/06/1998
IT	Italy	01/06/1998
JM	Jamaica	01/06/1998
JO	Jordan	01/06/1998
JP	Japan	01/06/1998
KE	Kenya	01/06/1998
KG	Kyrgyzstan	01/06/1998
KH	Cambodia	01/06/1998
KI	Kiribati	01/06/1998
KM	Comoros	01/06/1998
KN	Saint Kitts and Nevis	01/06/1998
KP	North Korea	01/06/1998
KR	Korea	01/06/1998
KW	Kuwait	01/06/1998
KY	Cayman Islands	01/06/1998
KZ	Kazakhstan	01/06/1998
LA	Laos	01/06/1998
LB	Lebanon	01/06/1998
LC	Saint Lucia	01/06/1998
LI	Liechtenstein	01/06/1998
LK	Sri Lanka	01/06/1998
LR	Liberia	01/06/1998
LS	Lesotho	01/06/1998
LT	Lithuania	01/06/1998
LU	Luxembourg	01/06/1998
LV	Latvia	01/06/1998
LY	Libya	01/06/1998
MA	Morocco	01/06/1998
MC	Monaco	01/06/1998
MD	Moldova	01/06/1998
MG	Madagascar	01/06/1998
MH	Marshall Islands	01/06/1998
MK	Macedonia, Former Yugoslav Republic of	01/06/1998
ML	Mali	01/06/1998
MM	Myanmar	01/06/1998
MN	Mongolia	01/06/1998
MO	Macao SAR	01/06/1998
MP	Northern Mariana Islands	01/06/1998
MQ	Martinique	01/06/1998
MR	Mauritania	01/06/1998
MS	Montserrat	01/06/1998
MT	Malta	01/06/1998
MU	Mauritius	01/06/1998
MV	Maldives	01/06/1998
MW	Malawi	01/06/1998
MX	Mexico	01/06/1998
MY	Malaysia	01/06/1998
MZ	Mozambique	01/06/1998
NA	Namibia	01/06/1998
NC	New Caledonia	01/06/1998
NE	Niger	01/06/1998
NF	Norfolk Island	01/06/1998
NG	Nigeria	01/06/1998
NI	Nicaragua	01/06/1998
NL	Netherlands	01/06/1998
NO	Norway	01/06/1998
NP	Nepal	01/06/1998
NR	Nauru	01/06/1998
NU	Niue	01/06/1998
NZ	New Zealand	01/06/1998
OM	Oman	01/06/1998
PA	Panama	01/06/1998
PE	Peru	01/06/1998
PF	French Polynesia	01/06/1998
PG	Papua New Guinea	01/06/1998
PH	Philippines	01/06/1998
PK	Pakistan	01/06/1998
PL	Poland	01/06/1998
PM	Saint Pierre and Miquelon	01/06/1998
PN	Pitcairn Islands	01/06/1998
PR	Puerto Rico	01/06/1998
PS	Palestinian Authority	01/06/1998
PT	Portugal	01/06/1998
PW	Palau	01/06/1998
PY	Paraguay	01/06/1998
QA	Qatar	01/06/1998
RE	Réunion	01/06/1998
RO	Romania	01/06/1998
RU	Russia	01/06/1998
RW	Rwanda	01/06/1998
SA	Saudi Arabia	01/06/1998
SB	Solomon Islands	01/06/1998
SC	Seychelles	01/06/1998
SD	Sudan	01/06/1998
SE	Sweden	01/06/1998
SG	Singapore	01/06/1998
SH	Saint Helena	01/06/1998
SI	Slovenia	01/06/1998
SJ	Svalbard and Jan Mayen	01/06/1998
SK	Slovakia	01/06/1998
SL	Sierra Leone	01/06/1998
SM	San Marino	01/06/1998
SN	Senegal	01/06/1998
SO	Somalia	01/06/1998
SR	Suriname	01/06/1998
ST	São Tomé and Príncipe	01/06/1998
SV	El Salvador	01/06/1998
SY	Syria	01/06/1998
SZ	Swaziland	01/06/1998
TC	Turks and Caicos Islands	01/06/1998
TD	Chad	01/06/1998
TF	French Southern and Antarctic Lands	01/06/1998
TG	Togo	01/06/1998
TH	Thailand	01/06/1998
TJ	Tajikistan	01/06/1998
TK	Tokelau	01/06/1998
TL	Timor-Leste	01/06/1998
TM	Turkmenistan	01/06/1998
TN	Tunisia	01/06/1998
TO	Tonga	01/06/1998
TR	Turkey	01/06/1998
TT	Trinidad and Tobago	01/06/1998
TV	Tuvalu	01/06/1998
TW	Taiwan	01/06/1998
TZ	Tanzania	01/06/1998
UA	Ukraine	01/06/1998
UG	Uganda	01/06/1998
UM	U.S. Minor Outlying Islands	01/06/1998
US	United States	01/06/1998
UY	Uruguay	01/06/1998
UZ	Uzbekistan	01/06/1998
VA	Vatican City	01/06/1998
VC	Saint Vincent and the Grenadine	01/06/1998
VE	Venezuela	01/06/1998
VG	Virgin Islands, British	01/06/1998
VI	Virgin Islands, U.S.	01/06/1998
VN	Vietnam	01/06/1998
VU	Vanuatu	01/06/1998
WF	Wallis and Futuna	01/06/1998
WS	Samoa	01/06/1998
YE	Yemen	01/06/1998
YT	Mayotte	01/06/1998
ZA	South Africa	01/06/1998
ZM	Zambia	01/06/1998
ZW	Zimbabwe	01/06/1998

Malheureusement la table Customer est trop lourde (je n'arrive pas à te l'envoyer)
Merci beaucoup pour ton aide !

**Chloooé** · 10/12/2018, 12h18

Table Customer (c'est juste un extrait mais ça peut certainement t'aider)

CustomerID	TerritoryID	AccountNumber	CustomerType	rowguid	ModifiedDate
1	1	AW00000001	S	{3F5AE95E-B87D-4AED-95B4-C3797AFCB74F}	13/10/2004 11:15:07
2	1	AW00000002	S	{E552F657-A9AF-4A7D-A645-C429D6E02491}	13/10/2004 11:15:07
3	4	AW00000003	S	{130774B1-DB21-4EF3-98C8-C104BCD6ED6D}	13/10/2004 11:15:07
4	4	AW00000004	S	{FF862851-1DAA-4044-BE7C-3E85583C054D}	13/10/2004 11:15:07
5	4	AW00000005	S	{83905BDC-6F5E-4F71-B162-C98DA069F38A}	13/10/2004 11:15:07
6	4	AW00000006	S	{1A92DF88-BFA2-467D-BD54-FCB9E647FDD7}	13/10/2004 11:15:07
7	1	AW00000007	S	{03E9273E-B193-448E-9823-FE0C44AEED78}	13/10/2004 11:15:07
8	5	AW00000008	S	{801368B1-4323-4BFA-8BEA-5B5B1E4BD4A0}	13/10/2004 11:15:07
9	5	AW00000009	S	{B900BB7F-23C3-481D-80DA-C49A5BD6F772}	13/10/2004 11:15:07
10	6	AW00000010	S	{CDB6698D-2FF1-4FBA-8F22-60AD1D11DABD}	13/10/2004 11:15:07
11	6	AW00000011	S	{750F3495-59C4-48A0-80E1-E37EC60E77D9}	13/10/2004 11:15:07
12	6	AW00000012	S	{947BCAF1-1F32-44F3-B9C3-0011F95FBE54}	13/10/2004 11:15:07
13	7	AW00000013	S	{B0FA5854-2511-439B-A7AC-50C9C460B175}	13/10/2004 11:15:07
14	8	AW00000014	S	{2F96BEDC-723D-468F-834B-B2B8AE79C849}	13/10/2004 11:15:07
15	9	AW00000015	S	{0340737B-D4FA-4795-93AA-CAEB8371BCF9}	13/10/2004 11:15:07
16	10	AW00000016	S	{C9381589-D31C-4EFE-8978-8D3449EB1F0F}	13/10/2004 11:15:07
17	5	AW00000017	S	{34DB417F-1E0B-4408-9FF6-987E59D0D73C}	13/10/2004 11:15:07
18	3	AW00000018	S	{C04D6B4D-94C6-4C5C-A44C-B449C0AC1B45}	13/10/2004 11:15:07
19	1	AW00000019	S	{69AE5D43-31BE-4B76-BFBB-5A23C4788BBC}	13/10/2004 11:15:07
20	1	AW00000020	S	{E010C10A-F1C3-4BBA-81CA-A7E083350400}	13/10/2004 11:15:07
21	4	AW00000021	S	{564E0B42-4609-43DE-9881-914DA433D82D}	13/10/2004 11:15:07
22	3	AW00000022	S	{9774AED6-D673-412D-B481-2573E470B478}	13/10/2004 11:15:07
23	4	AW00000023	S	{733F8250-3251-4C2A-8C85-C285BB76B7B4}	13/10/2004 11:15:07
24	4	AW00000024	S	{C111E51D-178D-4DBD-A6FF-F1CCBF4B1AAD}	13/10/2004 11:15:07
25	4	AW00000025	S	{31D03546-FB2A-4488-890E-4709A659E3F0}	13/10/2004 11:15:07
26	5	AW00000026	S	{FD4898DE-D128-4719-8C74-9F77605AAC4A}	13/10/2004 11:15:07
27	5	AW00000027	S	{CACA5149-D799-473B-847F-83F3613D3D1F}	13/10/2004 11:15:07
28	6	AW00000028	S	{9B8A04A4-D909-4F49-B1C5-3DE317D69B2A}	13/10/2004 11:15:07
29	6	AW00000029	S	{ECA7C8FA-490B-4B97-9C32-043C90F789E8}	13/10/2004 11:15:07
30	6	AW00000030	S	{2B15DFB1-831E-49E7-B337-395798B129E7}	13/10/2004 11:15:07
31	7	AW00000031	S	{EFFA209A-A110-4F94-887D-E50E44FB06EA}	13/10/2004 11:15:07
32	8	AW00000032	S	{B9A28813-542A-4FBF-AE79-BAD64A5E133B}	13/10/2004 11:15:07
33	9	AW00000033	S	{E6D92B96-FA82-41C0-8945-66A8A5EC017B}	13/10/2004 11:15:07
34	10	AW00000034	S	{9EDDA794-7862-4FF4-B8E2-528847CAB2BD}	13/10/2004 11:15:07
35	2	AW00000035	S	{8D74B6B9-6C96-44A5-BEC4-0E9736D191BE}	13/10/2004 11:15:07
36	2	AW00000036	S	{53C0491D-8AE8-4B16-A830-2078FDDF46AD}	13/10/2004 11:15:07
37	1	AW00000037	S	{C6EBB29A-CC67-459C-90E3-339E0F912906}	13/10/2004 11:15:07
38	1	AW00000038	S	{E5EDA3F3-4EF1-4806-BD36-E61F3CB2E044}	13/10/2004 11:15:07
39	3	AW00000039	S	{6808B1ED-3C9A-401D-B284-9AC31166D9EB}	13/10/2004 11:15:07
40	4	AW00000040	S	{AA5E28F6-16C8-4D80-894E-17531F2CF972}	13/10/2004 11:15:07
41	4	AW00000041	S	{E1BA20ED-DA19-4392-A8A8-C2E670438FFB}	13/10/2004 11:15:07
42	4	AW00000042	S	{64ACD300-337D-4D39-A2C4-FD5972611934}	13/10/2004 11:15:07
43	1	AW00000043	S	{9E449D3E-5D79-4F65-A4F1-10DD3B0E0766}	13/10/2004 11:15:07
44	5	AW00000044	S	{FB4B073C-6B38-4233-83FE-4236558F4754}	13/10/2004 11:15:07
45	5	AW00000045	S	{B50043ED-C66B-4130-BEBC-07D413043991}	13/10/2004 11:15:07
46	6	AW00000046	S	{21849ECF-88C2-4574-89D5-397B84DF1D0F}	13/10/2004 11:15:07
47	6	AW00000047	S	{0D9ABE85-D952-432D-831A-8BEB7F4E49D0}	13/10/2004 11:15:07
48	6	AW00000048	S	{E656589A-198F-454F-B02F-9CE324457BDF}	13/10/2004 11:15:07
49	7	AW00000049	S	{F3DFA401-85C6-4118-B5C5-6554310A1192}	13/10/2004 11:15:07
50	8	AW00000050	S	{0A3E846A-2DCC-4B6E-8AB3-968B5AB859F4}	13/10/2004 11:15:07
51	9	AW00000051	S	{E4C69E3E-BE4B-4DCD-B2F0-1237B391BC44}	13/10/2004 11:15:07
52	10	AW00000052	S	{8FB34B30-B19D-4AEC-B02E-F1BE942800E5}	13/10/2004 11:15:07
53	2	AW00000053	S	{81D3B740-DCF1-4F23-A5E3-D81353280016}	13/10/2004 11:15:07
54	2	AW00000054	S	{123B3EBF-4EB0-442A-8482-A4E001CCCF89}	13/10/2004 11:15:07
55	1	AW00000055	S	{F5D3997B-AD06-46A0-94AF-A4460F4BE471}	13/10/2004 11:15:07
56	1	AW00000056	S	{570B1682-9BB1-4359-984D-8F728E3D6973}	13/10/2004 11:15:07
57	3	AW00000057	S	{7FF17923-E670-4F42-87A3-A6D1AF18EA05}	13/10/2004 11:15:07
58	3	AW00000058	S	{E324FEE8-1EE7-4B96-854E-CFDA7B0CBBC8}	13/10/2004 11:15:07
59	4	AW00000059	S	{60708606-604C-44BE-90E1-3A0925B8060E}	13/10/2004 11:15:07
60	4	AW00000060	S	{A029F31E-433B-4FA4-B442-B291D16A1B9F}	13/10/2004 11:15:07
61	4	AW00000061	S	{CCC53B43-66A6-47F6-A38E-5DD7CFAFEAA6}	13/10/2004 11:15:07
62	5	AW00000062	S	{359BB644-407D-4C24-AB98-E637AEE7C81E}	13/10/2004 11:15:07
63	5	AW00000063	S	{76E2E4C3-B1BA-4CB2-B410-A4D48BA886E5}	13/10/2004 11:15:07
64	6	AW00000064	S	{E6B6F92D-4AC6-4BC7-BF6B-2F3C67498DE7}	13/10/2004 11:15:07
65	6	AW00000065	S	{7E082443-8AF6-4BB6-A0F5-1586271D1F2C}	13/10/2004 11:15:07
66	6	AW00000066	S	{E91E0048-9A25-489B-96C1-D726DA68FB7C}	13/10/2004 11:15:07
67	7	AW00000067	S	{51CE3843-FC98-453E-8CF1-7EA145235D0F}	13/10/2004 11:15:07
68	8	AW00000068	S	{2138DEF5-80EB-4D95-B340-706BCD60ADDA}	13/10/2004 11:15:07
69	9	AW00000069	S	{64841B37-3A25-416A-A129-E9AAA2EFF4CD}	13/10/2004 11:15:07
70	10	AW00000070	S	{89E10B04-064E-4313-8203-91FA98A01B11}	13/10/2004 11:15:07
71	2	AW00000071	S	{91CC8AC7-27E5-437C-B940-DB47692754D3}	13/10/2004 11:15:07
72	2	AW00000072	S	{0DA3081D-FDC7-4005-B77D-E5AFD8C15DE6}	13/10/2004 11:15:07
73	1	AW00000073	S	{9D5C135E-BD60-46E0-B371-843391637827}	13/10/2004 11:15:07
74	1	AW00000074	S	{73485E57-076D-4B10-BB48-6043DD873582}	13/10/2004 11:15:07
75	4	AW00000075	S	{55CFED0E-1A7B-409C-9AFF-297065965870}	13/10/2004 11:15:07
76	3	AW00000076	S	{5227D299-B05E-4D6C-A1C9-DA63154869BA}	13/10/2004 11:15:07
77	4	AW00000077	S	{B3F9113C-8FCE-47E1-9F04-38A0C68917C6}	13/10/2004 11:15:07
78	4	AW00000078	S	{8C8083AB-7943-44FA-B1AD-8E3ABD5D66EE}	13/10/2004 11:15:07
79	3	AW00000079	S	{010D8AA6-CEBA-4097-9E67-3B2A9674FD5F}	13/10/2004 11:15:07
80	5	AW00000080	S	{98DCB8C4-E7C0-43E7-B429-2CB4D8A8D90D}	13/10/2004 11:15:07
81	5	AW00000081	S	{E25E3769-CADC-4DA6-9120-09C3B2205475}	13/10/2004 11:15:07
82	6	AW00000082	S	{92618ECE-2254-4852-B3B3-46ED2E0E3E1A}	13/10/2004 11:15:07
83	6	AW00000083	S	{8E01F170-64D3-4B74-82E1-D1691AE9F37C}	13/10/2004 11:15:07
84	6	AW00000084	S	{45A614CE-3137-4A12-8296-24048C18F320}	13/10/2004 11:15:07
85	7	AW00000085	S	{B44000F5-901B-4134-979D-F9A9BEA5A598}	13/10/2004 11:15:07
86	8	AW00000086	S	{2A8B2702-4644-4002-90E4-99A8ADBA5261}	13/10/2004 11:15:07
87	9	AW00000087	S	{07FB8B21-FB06-49F8-8CD5-9956273CD78A}	13/10/2004 11:15:07
88	10	AW00000088	S	{11FEDA31-15B6-4F08-9357-355371D4D928}	13/10/2004 11:15:07
89	2	AW00000089	S	{A34FE994-1098-439F-A042-EE670BF2FA33}	13/10/2004 11:15:07
90	5	AW00000090	S	{6FC7D1F9-11E6-4574-90B3-7AA6FFC1EBD9}	13/10/2004 11:15:07
91	1	AW00000091	S	{9F314FC3-9644-4412-A90A-5483F75F665B}	13/10/2004 11:15:07
92	1	AW00000092	S	{672412C3-5D5D-488B-B176-E3DAFAD05D70}	13/10/2004 11:15:07
93	4	AW00000093	S	{249B42C2-8EAE-49F1-A560-A90837748654}	13/10/2004 11:15:07
94	4	AW00000094	S	{65BE08DA-DFB7-4BC8-AA5C-FAD98B82524E}	13/10/2004 11:15:07
95	4	AW00000095	S	{EA0BC621-9466-4F04-BBFF-3B361C6F9057}	13/10/2004 11:15:07
96	4	AW00000096	S	{BAC5B4DA-00B0-4BF1-816A-1E39F676BF9B}	13/10/2004 11:15:07
97	4	AW00000097	S	{355EB5D8-6B4C-4FFF-B12B-40F89CA4E31D}	13/10/2004 11:15:07
98	5	AW00000098	S	{7D37485D-A4CF-4C08-8D3C-364DEEC7C841}	13/10/2004 11:15:07
99	5	AW00000099	S	{8583A63E-3459-44C7-8736-A92E0A7135F2}	13/10/2004 11:15:07
100	6	AW00000100	S	{E789F6DD-3159-4DDC-81A8-8571C571656E}	13/10/2004 11:15:07
101	6	AW00000101	S	{67AD4F37-2467-4438-A749-D947BEEC3A92}	13/10/2004 11:15:07
102	6	AW00000102	S	{959CF74B-1004-43F5-9AB7-4CDD482C847D}	13/10/2004 11:15:07
103	7	AW00000103	S	{22390E6F-AC5F-4DED-8EE5-91C1302C7FA2}	13/10/2004 11:15:07
104	8	AW00000104	S	{FFBE0510-53BE-46D9-9406-63AFEE95DE3A}	13/10/2004 11:15:07
105	9	AW00000105	S	{F9387EA3-EF35-49B2-B535-E02368D2C0FD}	13/10/2004 11:15:07
106	10	AW00000106	S	{AAFBF7D5-8759-4962-9DEB-77C6E22875F4}	13/10/2004 11:15:07
107	2	AW00000107	S	{9522CA57-0246-496A-AE49-D9821CD67817}	13/10/2004 11:15:07
108	2	AW00000108	S	{D1E756E0-A0D1-43D6-A7CB-AC5C5EF404E7}	13/10/2004 11:15:07
109	1	AW00000109	S	{7585790B-6034-4520-A383-9FA1E8B3E76E}	13/10/2004 11:15:07
110	1	AW00000110	S	{82C2F3F0-63B8-46CC-AEDC-3A856956EF04}	13/10/2004 11:15:07
111	3	AW00000111	S	{0122151A-9140-4663-A3EB-A442D88BC1BB}	13/10/2004 11:15:07
112	4	AW00000112	S	{5035E4D6-3758-4FA6-A462-2E2ECF52E6F0}	13/10/2004 11:15:07
113	4	AW00000113	S	{8A84966C-5D38-41CA-990F-AD107558A6B8}	13/10/2004 11:15:07
114	4	AW00000114	S	{BCC5AE61-8214-44A1-A43C-FBD65C3745AE}	13/10/2004 11:15:07
115	1	AW00000115	S	{080F7047-8396-4CEC-AB43-56CF41DE4E00}	13/10/2004 11:15:07
116	5	AW00000116	S	{061C4697-F808-4C31-823E-5E8E60EFE0AA}	13/10/2004 11:15:07
117	5	AW00000117	S	{18406109-F4AC-4F30-A96F-4E056996DE56}	13/10/2004 11:15:07
118	6	AW00000118	S	{5FEAFBD2-4A43-4641-8E94-B3059B2A882E}	13/10/2004 11:15:07
119	6	AW00000119	S	{D13245EF-8267-4CB4-87C9-C23155D33E93}	13/10/2004 11:15:07
120	6	AW00000120	S	{25863C18-4C9A-4BC9-BE0D-95F4CF67BF7D}	13/10/2004 11:15:07
121	7	AW00000121	S	{7472FF87-0FBC-4D1F-B599-D47B51B41CF0}	13/10/2004 11:15:07
122	8	AW00000122	S	{094EB96D-D265-474D-869E-D9BACE4745A7}	13/10/2004 11:15:07
123	9	AW00000123	S	{BC0A8115-7E8F-4FAA-947F-FD315C30250D}	13/10/2004 11:15:07
124	10	AW00000124	S	{2F614C31-ABAE-42D0-820B-193F0DDC811E}	13/10/2004 11:15:07
125	2	AW00000125	S	{69AF6E37-EAD1-4FBD-82F0-61CE3B35F943}	13/10/2004 11:15:07
126	2	AW00000126	S	{B03EFE01-3333-4805-9913-99323C143526}	13/10/2004 11:15:07
127	1	AW00000127	S	{EF55103F-ACC7-4BFD-89B1-20A04845E706}	13/10/2004 11:15:07
128	1	AW00000128	S	{03F73E74-8DE5-421E-B5AF-04B259268DD6}	13/10/2004 11:15:07
129	3	AW00000129	S	{E03DB34C-BF17-407D-9423-FA22DBFDD292}	13/10/2004 11:15:07
130	4	AW00000130	S	{606ECDC2-6443-4E4B-897F-32D4C17AB894}	13/10/2004 11:15:07
131	4	AW00000131	S	{ED0DF7CC-6234-4D60-8B81-315C019F5356}	13/10/2004 11:15:07
132	3	AW00000132	S	{7649E8AF-3DAB-43AA-B7DF-9776F84DFB71}	13/10/2004 11:15:07
133	4	AW00000133	S	{4F61574B-8353-42EC-825C-87896E6E16A4}	13/10/2004 11:15:07
134	5	AW00000134	S	{FD0D8467-48D9-42B8-A4E6-DABC96F58925}	13/10/2004 11:15:07
135	5	AW00000135	S	{DFFD552F-30E0-488A-AC07-83C9A7B075C7}	13/10/2004 11:15:07
136	6	AW00000136	S	{84CD4767-F142-4D9D-9033-AD3ADE34BF74}	13/10/2004 11:15:07
137	6	AW00000137	S	{D6A1AEE7-25EF-4417-AB10-65BC21661864}	13/10/2004 11:15:07
138	6	AW00000138	S	{91B9EF4B-2FA8-4936-AC71-1FA1B3624D12}	13/10/2004 11:15:07
139	7	AW00000139	S	{23A1A3E2-16F0-40AA-87D4-F4AE97D12581}	13/10/2004 11:15:07
140	8	AW00000140	S	{01CD7E33-EDD0-46A9-8505-F3E85D9F21F4}	13/10/2004 11:15:07
141	9	AW00000141	S	{E0B29CC8-066D-4F7F-98C3-0F5136BB85D9}	13/10/2004 11:15:07
142	10	AW00000142	S	{B821D13F-E9DB-4A3B-87D0-7E867A161575}	13/10/2004 11:15:07
143	2	AW00000143	S	{95E93EFE-78E9-470C-B4A7-4DD6A5D0F14B}	13/10/2004 11:15:07
144	2	AW00000144	S	{53C1A4AC-2DE2-4AB5-808F-523BE758AD29}	13/10/2004 11:15:07
145	1	AW00000145	S	{FEC5609D-042B-4480-B1BA-55F2D4107327}	13/10/2004 11:15:07
146	1	AW00000146	S	{5475E9DD-98CA-4989-B7A2-3FC929BEEA12}	13/10/2004 11:15:07
147	3	AW00000147	S	{03836A0B-7AD8-4115-8D23-6EFA0D8DEEA1}	13/10/2004 11:15:07
148	3	AW00000148	S	{79355855-A002-4393-BB6E-36F90913FA4D}	13/10/2004 11:15:07
149	3	AW00000149	S	{BAA99D94-2FC2-4A1C-8B67-2C3210EB90C3}	13/10/2004 11:15:07
150	4	AW00000150	S	{285C5DD7-75D6-460D-97BA-AA86D86637C0}	13/10/2004 11:15:07
151	4	AW00000151	S	{7F2891F7-DD88-470B-95AE-CC9A7D732B1F}	13/10/2004 11:15:07
152	5	AW00000152	S	{E07B697E-74C1-4F52-818F-32531696F7AB}	13/10/2004 11:15:07
153	5	AW00000153	S	{10C2DA66-32A2-4C63-998F-9B18CDD6E3B0}	13/10/2004 11:15:07
154	6	AW00000154	S	{4F60F75E-B20A-4056-874C-B7F3BD33BF3F}	13/10/2004 11:15:07
155	6	AW00000155	S	{3B56CD66-5DDF-430C-AB41-3FF6A1836868}	13/10/2004 11:15:07
156	6	AW00000156	S	{CFFFAAFB-98DC-4392-84F9-FB3229F35265}	13/10/2004 11:15:07
157	7	AW00000157	S	{DA4968B5-6BA0-4478-BBDC-3A00E9A1B59E}	13/10/2004 11:15:07
158	8	AW00000158	S	{C48CFB9B-45A2-4DC2-B932-BA8C2572E833}	13/10/2004 11:15:07
159	9	AW00000159	S	{EB0F31C8-C2CF-46CD-8F92-C4059190A9C6}	13/10/2004 11:15:07
160	10	AW00000160	S	{B42D510D-3AE4-4911-88CF-8D90D6BD0922}	13/10/2004 11:15:07
161	2	AW00000161	S	{5A1817B3-6C90-4C17-ADF8-B30A06F92141}	13/10/2004 11:15:07
162	2	AW00000162	S	{F4D0EE10-E276-4A3D-8D3B-E1904195F1B8}	13/10/2004 11:15:07
163	1	AW00000163	S	{989F9F3A-7CB8-4083-8CDA-291C682BE73C}	13/10/2004 11:15:07
164	1	AW00000164	S	{5A323ACA-74A2-4CA0-AA3B-E1AE299AAD08}	13/10/2004 11:15:07
165	4	AW00000165	S	{3CDBD3EA-DA78-4F9A-8EEC-8DA4C050C817}	13/10/2004 11:15:07
166	4	AW00000166	S	{F644D9DC-4CED-49E8-8587-CE859E466DFA}	13/10/2004 11:15:07
167	4	AW00000167	S	{515D4A13-4E60-4D0C-8F22-BB89A9D312AD}	13/10/2004 11:15:07
168	4	AW00000168	S	{FCE18386-F492-4D4A-A6D2-FB7EF20C57FC}	13/10/2004 11:15:07
169	1	AW00000169	S	{2D6BBC35-BC19-4CB4-A61B-46899D3A4237}	13/10/2004 11:15:07
170	5	AW00000170	S	{1F8334E8-3DDC-4530-A1D2-E0BAB826476E}	13/10/2004 11:15:07
171	5	AW00000171	S	{3C40E926-090D-4A7A-9E9D-D9222AE910C5}	13/10/2004 11:15:07
172	6	AW00000172	S	{324C671D-DD10-4EE2-857A-767917ACC2A3}	13/10/2004 11:15:07
173	6	AW00000173	S	{FDC12E98-898B-4C22-972F-F0EBFBFCB7B0}	13/10/2004 11:15:07
174	6	AW00000174	S	{9C4DDEFA-AABD-4A51-AB90-998985FB7D2F}	13/10/2004 11:15:07
175	7	AW00000175	S	{66F2342A-7CC4-4F5F-A218-8791B21A9173}	13/10/2004 11:15:07
176	8	AW00000176	S	{10219F9C-BEF1-4CAC-A435-D75342C43153}	13/10/2004 11:15:07
177	9	AW00000177	S	{6ABC1437-87FF-49FE-8B91-9EEEEB4143D4}	13/10/2004 11:15:07
178	10	AW00000178	S	{05B8FB77-FC67-4279-AEBD-4162D21B9A11}	13/10/2004 11:15:07
179	2	AW00000179	S	{F7F8B200-1294-4419-9DAC-8194231AC9B7}	13/10/2004 11:15:07
180	3	AW00000180	S	{F7CFF29E-F164-424E-B005-BF8CF317AF27}	13/10/2004 11:15:07
181	1	AW00000181	S	{3D3D4CD0-7F5D-4BD9-A589-08881095BC5A}	13/10/2004 11:15:07
182	1	AW00000182	S	{D3DA2FF4-51C0-4FCB-A936-1B910458D752}	13/10/2004 11:15:07
183	3	AW00000183	S	{B2051957-B411-44E1-BCA5-63FECB5368F2}	13/10/2004 11:15:07
184	4	AW00000184	S	{A65C523A-498D-4314-A727-D17A8B2779F6}	13/10/2004 11:15:07
185	4	AW00000185	S	{5014E91D-7B0E-495A-B429-FF915BE9D2FD}	13/10/2004 11:15:07
186	4	AW00000186	S	{48D3E26E-C051-4B24-A37F-A88F5294F25F}	13/10/2004 11:15:07
187	4	AW00000187	S	{3329CE97-BB9F-4C36-9197-A6EEE803BD94}	13/10/2004 11:15:07
188	5	AW00000188	S	{2AF36044-25F9-476C-961D-A8EFD29E2C4F}	13/10/2004 11:15:07
189	5	AW00000189	S	{3ED50D2B-A57B-4238-BB31-2F96996DB362}	13/10/2004 11:15:07
190	6	AW00000190	S	{91154406-0118-4A11-BB1B-366EDFB5C97A}	13/10/2004 11:15:07
191	6	AW00000191	S	{A2F63E12-1C66-41C2-AAC0-57D87F1861D9}	13/10/2004 11:15:07
192	6	AW00000192	S	{84401968-8977-4380-9B4E-D5149C8126C0}	13/10/2004 11:15:07
193	7	AW00000193	S	{74CB0417-1626-4586-A8C8-6F0331B08C50}	13/10/2004 11:15:07
194	8	AW00000194	S	{3941081B-24ED-44F1-8009-CD17693423A0}	13/10/2004 11:15:07
195	9	AW00000195	S	{CD4CC2C3-9FB4-4DAB-95CC-A054B1171786}	13/10/2004 11:15:07
196	10	AW00000196	S	{5F0EB2D3-4691-4F71-8E9B-A3EACFA4A1D5}	13/10/2004 11:15:07
197	3	AW00000197	S	{47B64828-BC4C-4940-AA23-92006BF0D7F1}	13/10/2004 11:15:07
198	3	AW00000198	S	{B17DE285-DF9A-487B-8773-75844A101CD0}	13/10/2004 11:15:07
199	1	AW00000199	S	{F0CD52D1-B838-451E-B015-5414AB7D9154}	13/10/2004 11:15:07
200	1	AW00000200	S	{7C96C878-A038-4B2F-825F-016C922D6407}	13/10/2004 11:15:07

**james68** · 10/12/2018, 12h51

oulah... va falloir remonter toute la structure.... et franchement pas trop le temps...
ne peux tu pas mettre un mdb a la place ?

**Chloooé** · 10/12/2018, 13h52

Quand j'ai mis mon tout premier message les tables se sont mises automatiquement en forme … mais je n'ai rien fait de spécial pour que ça fasse cela ... et je ne sais pas comment faire du coup (c'est quoi un MDB ?)

Désolée d'être aussi perdue ... merci pour ta patience

**james68** · 10/12/2018, 15h16

je te reponds en PV.. ++

Problème fusion de deux requêtes [Toutes versions]

Access

Partager

Partager