I'm using the ADODB text driver to query some .dat files. I want to be able to query two seperate files and merge the results into one recordset. It seems like a Union query is what I should be doing.
Individually, this works...
"SELECT a.CE, a.REMARK, b.TEAM, Count(a.REMARK) AS RmkCount "...