Miles

SELECT     '1' AS ID, 'Issues' AS [Action], [tab_STK_RAW STOCK].[Stock Reference], [tab_STK_RAW STOCK].[Short Description],                       [tab_STK_RAW STOCK].[Opening Balance], [tab_STK_RAW STOCK ISSUES].DateStamp, CONVERT(varchar, [tab_WRK_WORKS ORDERS].[Order No])                       AS [Works Order No], CONVERT(varchar, [tab_STK_RAW STOCK ISSUES].[Cutting Instruction No]) AS [Cutting Instruction No],                       [tab_WRK_CUTTING INSTRUCTIONS].[FG Stock Reference], [tab_STK_RAW STOCK ISSUES].[Quantity Issued], '-' + CONVERT(varchar,                       [tab_STK_RAW STOCK ISSUES].[Quantity Issued]) AS Quantity, '' AS Description,                       [OPENING BALANCE] - [ISSUES] + [RECEIPTS] + [ADJUSTMENT] AS INSTOCKFROM         ([tab_STK_RAW STOCK] INNER JOIN                      ([tab_STK_RAW STOCK ISSUES] INNER JOIN                      [tab_WRK_CUTTING INSTRUCTIONS] ON                       [tab_STK_RAW STOCK ISSUES].[Cutting Instruction No] = [tab_WRK_CUTTING INSTRUCTIONS].[Cutting Order No]) ON                       [tab_STK_RAW STOCK].[Stock Reference] = [tab_STK_RAW STOCK ISSUES].[Stock Reference]) INNER JOIN                      [tab_WRK_WORKS ORDERS] ON [tab_STK_RAW STOCK ISSUES].[Works Order No] = [tab_WRK_WORKS ORDERS].[Works Order No]UNIONSELECT     '3' AS ID, 'Adjustment' AS [Action], [tab_STK_RAW STOCK].[Stock Reference], [tab_STK_RAW STOCK].[Short Description],                       [tab_STK_RAW STOCK].[Opening Balance], [tab_STK_RAW STOCK ADJUSTMENTS].DateStamp, 'N/A' AS [Works Order No],                       'N/A' AS [Cutting Instruction No], 'N/A' AS [FG Stock Reference], CONVERT(varchar, [tab_STK_RAW STOCK ADJUSTMENTS].[Quantity Adjusted])                       AS [Quantity Issued], [tab_STK_RAW STOCK ADJUSTMENTS].[Quantity Adjusted] AS [Quantity], [Notes] AS Description,                       [OPENING BALANCE] - [ISSUES] + [RECEIPTS] + [ADJUSTMENT] AS INSTOCKFROM         [tab_STK_RAW STOCK] INNER JOIN                      [tab_STK_RAW STOCK ADJUSTMENTS] ON [tab_STK_RAW STOCK].[Stock Reference] = [tab_STK_RAW STOCK ADJUSTMENTS].[Stock Reference]UNIONSELECT     '2' AS ID, 'Receipt' AS [Action], [tab_STK_RAW STOCK].[Stock Reference], [tab_STK_RAW STOCK].[Short Description],                       [tab_STK_RAW STOCK].[Opening Balance], [tab_STK_RAW STOCK RECEIPTS].DateStamp,                       'PO : ' + [Purchase Order No] + ' GRN : ' + [Purchase Order Desc] AS [Works Order No], 'N/A' AS [Cutting Instruction No], 'N/A' AS [FG Stock Reference],                       [tab_STK_RAW STOCK RECEIPTS].[Quantity Received] AS [Quantity Issued], [tab_STK_RAW STOCK RECEIPTS].[Quantity Received] AS Quantity,                       '' AS Description, [OPENING BALANCE] - [ISSUES] + [RECEIPTS] + [ADJUSTMENT] AS INSTOCKFROM         ([tab_STK_RAW STOCK] RIGHT JOIN                      [tab_STK_RAW STOCK RECEIPTS] ON [tab_STK_RAW STOCK].[Stock Reference] = [tab_STK_RAW STOCK RECEIPTS].[Stock Reference]) INNER JOIN                      qry_stk_grn_details ON [tab_STK_RAW STOCK RECEIPTS].[GRN Item No] = qry_stk_grn_details.Item_ID