SELECT 1,1,b.*,c.* FROM
(SELECT 1,SUM(worth) AS outworth, SUM(IF(SUBSTRING(createtime,6,2)='01',worth,0)) AS jan,
SUM(IF(SUBSTRING(createtime,6,2)='02',worth,0)) AS feb, SUM(IF(SUBSTRING(createtime,6,2)='03',worth,0)) AS mar,
SUM(IF(SUBSTRING(createtime,6,2)='04',worth,0)) AS apr, SUM(IF(SUBSTRING(createtime,6,2)='05',worth,0)) AS may,
SUM(IF(SUBSTRING(createtime,6,2)='06',worth,0)) AS june, SUM(IF(SUBSTRING(createtime,6,2)='07',worth,0)) AS july,
SUM(IF(SUBSTRING(createtime,6,2)='08',worth,0)) AS aug, SUM(IF(SUBSTRING(createtime,6,2)='09',worth,0)) AS sep,
SUM(IF(SUBSTRING(createtime,6,2)='10',worth,0)) AS octo, SUM(IF(SUBSTRING(createtime,6,2)='11',worth,0)) AS nov,
SUM(IF(SUBSTRING(createtime,6,2)='12',worth,0)) AS dece FROM storage_out
WHERE STATUS=1 AND createtime LIKE '2013%' AND employee_id IN
(SELECT id FROM employee WHERE department IN (10000))) b
LEFT JOIN(SELECT 1,SUM(worth) AS returnworth, SUM(IF(SUBSTRING(createtime,6,2)='01',worth,0)) AS jan,
SUM(IF(SUBSTRING(createtime,6,2)='02',worth,0)) AS feb, SUM(IF(SUBSTRING(createtime,6,2)='03',worth,0)) AS mar,
SUM(IF(SUBSTRING(createtime,6,2)='04',worth,0)) AS apr, SUM(IF(SUBSTRING(createtime,6,2)='05',worth,0)) AS may,
SUM(IF(SUBSTRING(createtime,6,2)='06',worth,0)) AS june, SUM(IF(SUBSTRING(createtime,6,2)='07',worth,0)) AS july,
SUM(IF(SUBSTRING(createtime,6,2)='08',worth,0)) AS aug, SUM(IF(SUBSTRING(createtime,6,2)='09',worth,0)) AS sep,
SUM(IF(SUBSTRING(createtime,6,2)='10',worth,0)) AS octo, SUM(IF(SUBSTRING(createtime,6,2)='11',worth,0)) AS nov,
SUM(IF(SUBSTRING(createtime,6,2)='12',worth,0)) AS dece FROM storage_return
WHERE STATUS=1 AND createtime LIKE '2013%' AND employee_id IN (SELECT id FROM employee WHERE department IN (10000)))c ON 1=1
稍作加工应该可以用,希望对你有用