Unable to display data in separate columns using UNION in mysql?

Question

I have written a mysql query that is getting data from two different tables stock_list and selected_items using union.From stock_list I am getting SUM(qty),SUM(weight).From selected_items I am getting COUNT( barcode ) and SUM( weight ) both based on a specific date.And the last query in the union returns the total SUM(qty),SUM(weight) from stock_list. This is the query I am using.

SELECT SUM( qty ) AS StockSum, SUM( weight ) AS Stockweight
FROM  `stock_list` 
WHERE DATE LIKE  '08-Jan-2016'
UNION SELECT COUNT( barcode ) AS BilledItems, SUM( weight ) AS Billedweight
FROM  `selected_items` 
WHERE DATE LIKE  '08-Jan-2016'
UNION SELECT SUM( qty ) AS TotalStock, SUM( weight ) AS TotalWeight
FROM  `stock_list`;

The problem is everything gets displayed in two columns StockSum and Stockweight.I would like to have 6 separate columns plus I would like to add an extra column for date at the beginning.

This is my current output.

This is my desired result that I would like to achieve.

This is my selected_items table.

This is my stock_list table

Answer 1

This is how to get the first 4 columns I think:

SELECT date,
       SUM( qty ) AS StockSum,
       SUM( stockW ) AS Stockweight,
       COUNT( barcode ) AS BilledItems,
       SUM( billedW ) AS Billedweight
FROM ( SELECT
          date,
          qty, weight AS stockW,
          null AS barcode, null AS billedW
       FROM stock_list
       UNION
       SELECT
          date,
          null AS qty, null AS stockW,
          barcode, weight AS billedW
       FROM selected_items
     )
GROUP BY date
ORDER BY date

For the final two columns, I think you want a running total of the stock up that date, for each date, and to program that, I'd use a PHP process rather than SQL.