How to join a column in one table to another

[triciagdaly]

In the attached example, I'm trying to add (join ) the column 'CP_AMOUNT'  in StdCostDateRange table to the Receipts table.  The common field is ITEM_NUMBER.

I tried  LEFT JOIN (Receipts) after the 'NoConcatenate' on the StdCostDateRange table, but it doesn't accept it.

[whiteline]

Hi.

I guess there is no RECEIPT_DATE field in your data model. So there is nothing to interval match an therefore nothing to join.