I have concatenated three tables. The data of one table(IpRecvg) creates multiple rows of the same original row. I don't know what I am doing wrong. Did I concatened incorrect? The script is:
TempReceivings: Sql SELECT UNIT_COST AS R_UNIT_COST, QUANTITY_RECVD AS R_QUANTITY_RECVD, EXTENDED_TOTAL AS R_EXTENDED_TOTAL, PO_NUMBER as R_PO_NUMBER , ITEM_NUMBER AS R_ITEM_NUMBER, INVOICE_NUMBER AS R_INVOICE_NUMBER, ACCOUNT AS R_ACCOUNT, JOB_NUMBER AS R_JOB_NUMBER, DESCRIPTION AS R_DESCRIPTION, STOCK_NUMBER AS R_STOCK_NUMBER, 'Receivings' as R_TABLE, DATE_RECEIVED AS R_DATE_RECEIVED from Jobscope.dbo.IpRecvg WHERE DATE_RECEIVED >= '20150713' AND INVOICE_NUMBER = '';
leftjoin (AP_RECEIVINGS_TEMP) Sql SELECT PO_NUMBER AS R_PO_NUMBER, VENDOR_NUMBER AS R_VENDOR_NUMBER from Jobscope.dbo.IPPOITM;
VendorInvoicesTemp: Sql SELECT ACCOUNT AS R_ACCOUNT, AMOUNT_INVOICED AS R_EXTENDED_TOTAL, DATE_VOUCHERED AS R_DATE_VOUCHERED, DESCRIPTION AS R_DESCRIPTION, ITEM_NUMBER AS R_ITEM_NUMBER, VENDOR_NUMBER AS R_VENDOR_NUMBER, INVOICE_NUMBER AS R_INVOICE_NUMBER, PO_NUMBER AS R_PO_NUMBER, 'AP' AS R_TABLE
from Jobscope.dbo.IPINVCE WHERE DATE_VOUCHERED >= '20140101' AND DATE_VOUCHERED <='20161231';
POTemp: Sql SELECT ACCOUNT AS R_ACCOUNT, COMPLETE AS R_COMPLETE, DESCRIPTION AS R_DESCRIPTION, EXT_TOTAL_CURR AS R_EXTENDED_TOTAL_PO_ITEM_VALUE, EXTENDED_TOTAL AS R_EXTENDED_TOTAL_ORIGINAL_CURR, PO_NUMBER AS R_PO_NUMBER, ITEM_NUMBER AS R_ITEM_NUMBER, JOB_NUMBER AS R_JOB_NUMBER, QUANTITY_ORDERED AS R_QUANTITY_ORDERED, QUANTITY_RECVD AS R_QUANTITY_RECVD, STOCK_NUMBER AS R_STOCK_NUMBER, UNIT_COST AS R_UNIT_COST_ORIGINAL_CURR, UNIT_COST_CURR AS R_UNIT_COST, VENDOR_NUMBER AS R_VENDOR_NUMBER, 'OpenPo' AS R_TABLE //'20250101' as R_DATE_VOUCHERED from Jobscope.dbo.IPPOITM WHERE COMPLETE <> 'C';
