I think you'll need to use the UNION clause which can't be done with the view designer. Try SELECT field1 AS X, field2 AS Y FROM table1 UNION SELECT field1 AS X, field2 AS Y FROM TABLE2 UNION SELECT FIELD1 AS X, FIELD2 AS Y FROM TABLE3 INTO CURSOR temp.

You might be able to use CREATE SQL VIEW to create a view from the SQL statement. I don't know if a view can handle the UNION clause or not.

Dick