am getting to many data while running the access database query

[Guest]

I have linked two table from excel database. What i want is the data from
both table in one table but i am not getting data i want. Once i run the
query it gives me to many data which duplicate (there are 2 data in both
table so new table should reflect the only 8 data but it is showing more than
4 data)
Table 1 :
Invoice No. Bll No.
333709 NRBA04407
LDN0904381 GLA821410

Table 2 :
Invoice No. Bill No.
LDN0741649 UK3090294
LDN0852649 UK3095143

Output Table should reflect only 4 data as mentioned above as follows :
Invoice No. Bll No.
333709 NRBA04407
LDN0904381 GLA821410
LDN0741649 UK3090294
LDN0852649 UK3095143

If you provide me live example with your expertise than it would be great.

Appreciate your kind assistance.

Thanks & Best Regards,
Kamlesh

 

[Marshall Barton]

I have linked two table from excel database. What i want is the data from
both table in one table but i am not getting data i want. Once i run the
query it gives me to many data which duplicate (there are 2 data in both
table so new table should reflect the only 8 data but it is showing more than
4 data)
Table 1 :
Invoice No. Bll No.
333709 NRBA04407
LDN0904381 GLA821410

Table 2 :
Invoice No. Bill No.
LDN0741649 UK3090294
LDN0852649 UK3095143

Output Table should reflect only 4 data as mentioned above as follows :
Invoice No. Bll No.
333709 NRBA04407
LDN0904381 GLA821410
LDN0741649 UK3090294
LDN0852649 UK3095143

That looks like you want to use a UNION query:

SELECT [Invoice No.], [Bill No.]
FROM table1
UNION
SELECT [Invoice No.], [Bill No.]
FROM table2

Note that you can not use the query design grid to do this,
it must be entered in the query's SQL view.