I 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
















Could you please advise me how to proceed further to get the data that i want.

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

Appreciate your kind assistance.

Thanks & Best Regards,
Kamlesh

 

[JohnFol]

Hi Kamlesh, what you don't mention is the query you use to get the 2 tables
into one. I think you should be using a Union query, something like

Select [Invoice No], [Bll No] from Table1
UNION ALL
Select [Invoice No], [Bll No] from Table2