Union / Pass through querries

[Jason Trolian]

I posted last week that I was trying to combine data from
2 tables in order to generate reports on total dollars
recovered.

I was advised by more then one to utilize a union query in
order to query the data i needed.

I created a union query that looked like this:

select [actcat], [actprin], [actotal]
from colacct
union
select [actcat], [actprin], [actotal]
from colachis

When I ran this query I received the following error:

ODBC call failed [Microsoft] [ODBC Visual F(#200)]

So, I read up on the error at Microsoft Knowledge Base
Article - 244904

I was instructed to create a SQL pass-through query that
uses the Microsoft Visual FoxPro ODBC driver to perform
the union query

So I did. I run the pass-through query and dont pull any
data up. Just 3 expressions that all reflect the field
names not the data I'm trying to query. Did I miss a step
somewhere?

Jason