tiptop 兩段select用 UNION 並求出料品，品名，數量 可是求不出？？

Question

LET l_sql = " SELECT rvv31,rvv031,rvu03,sum(rvv17) ",                     " FROM rvv_file,rvu_file ",                     " WHERE rvv01 = rvu01 ",                     " AND rvuconf = 'Y'",                     " AND rvuacti = 'Y'",                     " AND rvu03 >='",tm.bmm,"' AND rvu03 <='",tm.emm,"' ",                     " AND ",tm.wc CLIPPED,                      " GROUP BY rvv31,rvv031,rvu03 ",                     " UNION ",                     " SELECT sfv04,ima02,sfu02,sum(sfv09) ",                     " FROM sfv_file,ima_file,sfu_file ",                     " WHERE sfv01 = sfu01 ",                     " AND ima01 = sfv04 ",                     " AND sfupost = 'Y' ",                     " AND sfu02 >='",tm.bmm,"' AND sfu02 <='",tm.emm,"' ",                     " GROUP BY sfv04,ima02,sfu02",　　　　　　　　　　 “ ORDER BY rvv31,sfv04”
             請各位高手指點，謝謝了

Answer 1

先把各自的查询分别进行后再合并试试吧.就是用括号分开,如
(select from group order) union (select from group order)