I need to create view but my query has one subquery !

[omid020]

I know that MySQL has restriction on creating views for those queries that have subqueries like my query but could you please help me to rewrite this query to resolve this issue ?

 

SELECT leafCode
     , colorsCode
     , COALESCE(SUM(`INPUT`), 0) AS `INPUT`
     , COALESCE(SUM(`OUTPUT`), 0) AS `OUTPUT`
     , COALESCE(SUM(`INPUT`), 0) - COALESCE(SUM(`OUTPUT`), 0) AS `INVENTORY`
  FROM ( SELECT rs_leaves.leafCode
              , rs_colors.colorsCode
              , SUM(receipt_details.recAmount) AS `INPUT`
              , NULL AS `OUTPUT`
           FROM receipt_details
         INNER JOIN rs_leaves
             ON rs_leaves.leafID = receipt_details.leafName
         INNER JOIN rs_colors
             ON rs_colors.colorsID = receipt_details.leafColor
         GROUP BY rs_leaves.leafCode
              , rs_colors.colorsCode
         UNION ALL
         SELECT rs_leaves.leafCode
              , rs_colors.colorsCode
              , NULL AS `INPUT`
              , SUM(assign_details.assAmount) AS `OUTPUT`
           FROM assign_details
         INNER JOIN rs_leaves
             ON rs_leaves.leafID = assign_details.leafName
         INNER JOIN rs_colors
             ON rs_colors.colorsID = assign_details.leafColor
         GROUP BY rs_leaves.leafCode
              , rs_colors.colorsCode
       ) AS humpty
GROUP BY leafCode
     , colorsCode

[fenway]

I can't even begin to make sense of that.