Select txtcountry,txtfilingno,txttaxdate,txttafinitials from 1Q02
Union Select txtcountry,txtfilingno,txttaxdate,txttafinitials from 2Q02
Union Select txtcountry,txtfilingno,txttaxdate,txttafinitials from 3Q02
UNION Select txtcountry,txtfilingno,txttaxdate,txttafinitials from 4Q02;
When I add up the record count for those tables, it is not the same number as my rows returned from the union statement. Not really familiar with writing unions. Any ideas?