I have created a union query in access database, which works lovely jubley.
However what I now need to do is create this view programaticaly using Vb6 Ado connection.
The usual Create View syntax does not seem to allow union queries.
CREATE VIEW CommonTable as select a from table1 union select a from table2
error = -2147217900
Unions not allowed in a subquery.
Clearly Access supports the Union as I copied the select statement from the design view of the UNION Query I created using MS Access.