Is there anyway to SELECT data from 2 different tables? The

Question

Is there anyway to SELECT data from 2 different tables? The

tables have no relation to each other,
They have the same structure, only one column is different

When I do something like this:
SELECT * FROM table1, table2;
It returns all columns from both tables, but no data

When I do cross join like this:
SELECT * FROM table1 CROSS JOIN table2;
The same result happens

What should I do?

0

08.09.2019

1 ответов

14 просмотров

Denis Efremov · Accepted Answer

Denis Efremov

Maybe UNION?

0

08.09.2019

Похожие чаты

Is there anyway to SELECT data from 2 different tables? The

1 ответов

Похожие вопросы