Concatenate tables

[ranibosch]

Hi all,

I'm struggling to concatenate tables in my script and would appreciate your help.

I would like to concatenate my value entries table with my item ledger entries table inorder to form a single table called ValueEntriesVsItemLedgerEntries

My script looks as follows:

//*******************************VALUE ENTRIES**************************************

ValueEntries:

Load

"Document No_" as "Shipment No",

"Document No_" as "Invoice/Credit note No",

"Item No_" as "Item No",

"Sales Amount (Actual)" as "Value Entries Sales Amount",

"Cost Amount (Actual)" AS "Value Entries Cost Amount";

SQL SELECT

    "Document No_",

    "Item No_",

    "Item Ledger Entry Type",

    "Item Ledger Entry Quantity",

    "Sales Amount (Actual)",

    "Cost Amount (Actual)"

FROM "DynamicsNAV90_Prod".dbo."Ambassador Foods (Pty) Ltd$Value Entry";

//*****************************ITEM LEDGER ENTRIES**********************************************

ItemLedgerEntries:

LOAD

"Document No_" as "Shipment No",

// Year("Posting Date") as "Year Sold",

// Month("Posting Date") as "Month Sold",

Pick (WildMatch("Entry Type", 0,1,2,3,4,5,6), 'Purchase','Sales','Positive Adjm.','Negative Adjm.','Transfer','Consumption','Output') as "Item Ledger Entry Type",

Quantity as "Tonnage Sold";

SQL SELECT

    "Document No_",

    "Posting Date",

    "Entry Type",

    Quantity

FROM "DynamicsNAV90_Prod".dbo."Ambassador Foods (Pty) Ltd$Item Ledger Entry";

Where "Entry Type" =  '1'

How do I concatenate these 2 tables?

[ranibosch]

Thank you very much..