Is it possible to add the results of two queries without union?

Question

SQL

My orm does not support union, is there any other option to join two tables?

of 4 columns: a.id, a.name, b.id, b.name make 2

Answer 1

Well, merge in the code or another option, make a storage and pull it already

Answer 2

Use a view (VIEW):

CREATE VIEW union_tables
AS
SELECT id, name FROM a
UNION ALL
SELECT id, name FROM b;