Hi. I'm trying to create a view so I can put 4 tables into one view.
Here's an example of SQL I was trying out:

CREATE VIEW INFO AS
(SELECT * FROM TRANS_PER_MIN
UNION ALL
SELECT * FROM BUFFY)

Problem is, all four tables have different numbers of columns because of that I get error message:
ORA-01789: query block has incorrect number of result columns.

Have I missed something in the SQL, or should I be using other joins to create the view?

Thanks for the help
Fiona