New Table from Other Tables

[evansabres]

I am wondering if it is possible to create a table comprised of values from other non-related tables.

I have table A with two fields that I would want, same with Table B, C, D & E, down the line. The fields are non-related but I want to create a summary table.

Is this possible?

[Gysbert_Wassenaar · Accepted solution]

Ah, you want to concatenate the tables.

Summary:

LOAD

     brandNME,

     videoNMEBB as videoNME,

     videoviewbb as videview

RESIDENT

     Table1;

CONCATENATE (Summary)

LOAD

     brandNME,

     videoNMEra as videoNME,

     videoviewra as videview

RESIDENT

     Table2;