Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.