Consolidate Tables with Inconsistent/Different columns

[Anonymous]

Hi All,

I'm currently having a hard time consolidating my tables that is pulling from an SQL Database

I Pulled 5 tables and each of them have different columns/columns name (please screenshot below):

1. Request Table:

2. Answer Table:

3. Question Table:

4. Queue Table:

and lastly, Vote table:

So the desired output is to atleast consolidate them in one table.

Is this feasible? if no, are there any other ways to achieve similar results?

Thank you in advanced! 🙂

[zenisekd]

@Anonymous  Can you draw the logic of if? Either the tables you mention are incorrectly named (so it is not possible to conclude, which table links to another table) or there is no id column in common so there is no way to consolidate it.