Alan,Brad, there are probably three or four ways to do what you're asking, but it will help if you give a business reason. For example, I can get you all the records from one file, followed by a row with the record count, then all the records from the second file, followed by a count. But remember that the result set must have the same columns in every row, so you end up with an additional column for the file name (which will be one of two values) and an addition column for the count (which will be zero for every records EXCEPT the two total records).
I was wondering if using a union on two files if I can construct a single
count(*) SQL command to count the total records from both files.