Adjust a QUERY

[Maurizio]

By ODBC Access 2000 gets data.
Into a ODBC's linked table I get CLF_RGSOC's data (none_ANACLF).
Into another ODBC's linked table I get accessory IRI_DESDI's data (none_INDIRI).

That's my problem:

with my under query I cannot get data which field .CLF_RGSOC have not an accessory IRI_DESDI's data to none_ANACLF.CLF_RGSOC. I'd like get (none_ANACLF.CLF_RGSOC) + (none_INDIRI.IRI_DESDI) of course empty.

Tia.


SELECT none_ANACLF.CLF_RGSOC, none_ANACLF.CLF_CD, none_INDIRI.IRI_DESDI, none_ANACLF.CLF_CAP, none_ANACLF.CLF_CIT, none_ANACLF.CLF_PRV, none_ANACLF.CLF_TEL, none_ANACLF.CLF_FAX, none_ANACLF.CLF_AZI
FROM none_ANACLF INNER JOIN none_INDIRI ON (none_ANACLF.CLF_MS = none_INDIRI.IRI_MS) AND (none_ANACLF.CLF_CD = none_INDIRI.IRI_CD) AND (none_ANACLF.CLF_AZI = none_INDIRI.IRI_AZI) WHERE (((none_ANACLF.CLF_AZI)=2) AND ((none_ANACLF.CLF_MS)=98));

8.xls
	A	B	C	D
1	none_ANACLF
2	CLF_CD	CLF_RGSOC
3	1	Carlo
4	2	Diego
5	3	Walter
6	4	Maury
7	5	Stephy
8
9	none_INDIRI
10	IRI_CD	none_INDIRI
11	2	Rome
12	4	Milan
13	5	Venice
14
15	Iget:
16	2	Diego	Rome
17	4	Maury	Milan
18	5	Stephy	Venice
19
20	I'dlike:
21	1	Carlo
22	2	Diego	Rome
23	3	Walter
24	4	Maury	Milan
25	5	Stephy	Venice
Foglio2

 

[bat17]

If you go into your query in design mode you can select and right-click the join between the two tables. this will bring up a box that will let you change them from from a standard join to one that will show all records for either of the tables. you will need to repeat it for each of the joins between the tables.


HTH

Peter

 

[Maurizio]

Hi Peter,
thanks and...

db.xls
	A	B	C	D	E
1	HowcanItotrasformDatalike:
2	DATA	CLI	DDT	DESCRIZ	PGRN
3	03/09/03	311	1	1619M-1364	1
4	03/09/03	311	1	A03449	2
5	03/09/03	311	1	2412M-617	3
6	03/09/03	17	2	2412M-171	1
7	03/09/03	17	2	2412M-889	2
8	03/09/03	17	2	1626M-1125	3
9	03/09/03	17	2	706D-1556	4
10	So:
11	DATA	CLI	DDT	DESCRIZ
12	03/09/03	311	1	1619M-1364/A03449/2412M-617
13	03/09/03	17	2	2412M-171/2412M-889/1626M-1125/706D-1556
DataBase

 

[bat17]

I don't think that you can using normal quries. You would need to use VBA to accumulate the data and save it to a new table.

Peter

 

[Maurizio]

Hi Peter,
thanks... and a little VBA help!?.