Re: Creating a view over identically structured tables

This wont work, cant have a union in a view..... }You could set up a small ace report to build you a "CREATE VIEW" SQL }statement. Use OUTPUT TO "CREATEVIEW.SQL" and base it on a: } SELECT TABNAME FROM SYSTABLES WHERE TABNAME MATCHES "oldtrx*" }and build something that writes the following: } CREATE VIEW alltables AS } SELECT * FROM oldtrx0195 } UNION } SELECT * FROM oldtrx0295 } UNION } etc... and i still want to know why not! Mike Aubury