Retrieving multiple rows into a listview control from an ODBC source works well for simple SELECTs with a statement attribute of SQL_SCROLLABLE. How do I do this with a UNION query?

select some_fields from table1
union
select same_fields from table2

select some_fields from table1
union
select same_fields from table2