How to merge tables with no common data?

1

Hello!
I have different tables with data, I want to group them into one table.

For example:
table 1: TV

Quantity Price Remaining
1 2 3

table 2: Refrigerators

Quantity Price Remaining
1 2 3

How can I create a general table of this type?

Name Quantity Price Remaining
TV 1 2 3
Refrigerators 1 2 3

Is this possible to do using the metabase interface?

2

You'd need to do a UNION query as a SQL question.

First, shoot the database designer, there's no way the database should have been designed like that!