这语句应该怎么写啊
select A.*,B.*FROM
(select '2:3酸99%' as 产品名称,
t1.fdecimal17 as 计划销售额
from t_BOS200002351entry t1 ,t_BOS200002351 t
where t.fid=t1.fid and t.finteger=2000) A,
(select
sum(fconsignamount) as 实际销售额
from ICStockBill i,ICStockBillentry i1
where i.finterid=i1.finterid and i1.fitemid=154
and i.ftrantype=21
and year(i.fdate)=2011 group by i1.fitemid) B
这是一条记录,还有多条记录需要union,
例如2:3酸98% i1.fitemid=153
这语句应该怎么写?
谢谢