General discussion
October 14, 2002 at 06:56 AM
ideafixer

Union does returns inproper num. of rows

by ideafixer . Updated 23 years, 10 months ago

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?

This discussion is locked

All Comments