sql语句怎么来连接起来呀！

Question

select t1.Nums1-t2.Nums2 Nums,t1.PRODUCTS_ID,t3.PRODNAME from
(select sum(num) Nums1,PRODUCTS_ID from jxc_t_outbound_detailed GROUP BY PRODUCTS_ID
) t1
left join (select sum(num) Nums2,PRODUCTS_ID from jxc_t_outbound_revise_detailed GROUP BY PRODUCTS_ID
) t2 on t1.PRODUCTS_ID=t2.PRODUCTS_ID
LEFT JOIN jxc_t_products t3 ON t1.PRODUCTS_ID=t3.ID
LEFT JOIN jxc_t_outbound_revise t4 ON t1.PRODUCTS_ID=t4.ID
WHERE LIMIT 10 order by TIME

select left(TIME,4) from jxc_t_outbound_revise （本年)
select left(TIME,7) from jxc_t_outbound_revise (本月）
怎么写才能使上面的语句加入where 加入条件按本年，本月呢？他们怎么连接起来？

Answer 1

你这个sql写的不明白，不过可以用分析函数一条语句实现.具体的可以百度，不会也可以再问