select query - Appending 2 tables

[Dennis H]

I start with tables x and y. Link DIST and OBS1
I get query1 with a select query.
I want to get Query WANTED.
I've tried NOT linking.

TABLE x
DIST OBS1 X CountOfSEG
3 09 1 62
3 09 1 63
3 09 1 69

TABLE Y
DIST OBS1 X CountOfSEG
3 09 2 7
3 09 2 81

Query1
DIST OBS1 X X.CountOfSEG Y.CountOfSEG
3 09 1 62 7
3 09 1 62 81
3 09 1 63 7
3 09 1 63 81
3 09 1 69 7
3 09 1 69 81

Query WANTED
DIST OBS1 X X.CountOfSEG
3 09 1 62
3 09 1 62
3 09 1 63
3 09 2 7
3 09 2 81



..

 

[Dennis]

I got it with a UNION Query.