select * from (
SELECT short_name,stock_total From
( SELECT *
FROM a ) a
GROUP BY short_name )a LEFT OUTER JOIN
(SELECT short_name, sale_total from
( SELECT *
FROM part_sale_info ) a GROUP BY
short_name)bON a.short_name = b.short_name
SELECT short_name,stock_total From
( SELECT *
FROM a ) a
GROUP BY short_name )a LEFT OUTER JOIN
(SELECT short_name, sale_total from
( SELECT *
FROM part_sale_info ) a GROUP BY
short_name)bON a.short_name = b.short_name
( SELECT *
FROM a ) a
GROUP BY short_name ) T1 LEFT JOIN SELECT short_name, sale_total from
( SELECT *
FROM part_sale_info ) B GROUP BY
short_name ) T2ON T1.short_name = T2.short_name
( SELECT *
FROM a ) a
) a LEFT OUTER JOIN ( SELECT short_name, sale_total from
( SELECT *
FROM part_sale_info ) a ) bON a.short_name = b.short_name GROUP BY
short_name
( SELECT *
FROM a ) a
) a LEFT OUTER JOIN ( SELECT short_name, sale_total from
( SELECT *
FROM part_sale_info ) a ) bON a.short_name = b.short_name GROUP BY
a.short_name