Create a new table by dividing some columns from two tables

Hey,

not sure if I totally understand your requirement, but maybe this will work.

In the Query Editor mark one table and choose "Merge Queries", this allows you to pull columns from the second table into the first table. Be aware, that the Merge Operation does not create a third table. If you really need three tables, copy the queri of one table first.

You have to select column in both tables (the keys), these table identify the same rows, whereas it is not necessary that there are same number of rows in each table identified by the key columns.

In a second step you can expand the newly content and just select the missing columns.

Now you can create custom columns where you divide the columns accordingly.

Hope this helps