Joining two tables

[samvile18]

Good afternoon everyone,

Can someone me please? I'm trying to join two exact tables together to make one master, I'm struggling with the script though.

I have the following:

ItemsOut:

LOAD DATE,

          CRDATE

          CRTIME,

          NODE,

          MEASURE

SQL SELECT *

FROM FPWFI;

I then have the same script to load the ItemsIn table, the main difference is the measure says Pipeline in one table and Outs in the other. How can I can add the Outs to the Pipeline so I end up with one master table showing both measures?

[Nicole-Smith]

Items:

LOAD DATE,

          CRDATE

          CRTIME,

          NODE,

          MEASURE;

SQL SELECT *

FROM FPWFI;

Concatenate(Items)

LOAD DATE,

          CRDATE

          CRTIME,

          NODE,

          MEASURE;

SQL SELECT *

FROM YourSecondSQLTable;

[#3]

Hi Sam,

I suggest to save each table (Items In, Items Out) in a different QVD then when you will load them as a single table use a flag to recognize them.

The other option is doing the next select

Items:

LOAD DATE,

          CRDATE

          CRTIME,

          NODE,

          MEASURE,

          'ITEMS OUT'      as ITEMTYPE;

SQL SELECT *

FROM FPWFI;

concatenate

LOAD DATE,

          CRDATE

          CRTIME,

          NODE,

          MEASURE,

          'ITEMS IN'      as ITEMTYPE;

SQL SELECT *

FROM ItemsInSQLTable;