请教各位高手一个sql的问题。
我先再有这样一条sql,其中
SELECT * FROM(
SELECT t.title INNERNAME,SUM(item.amount) AMOUNT
FROM t_order o, t_orderItem item,t_priceRecp,
t_columnlefttreetree,
t_article t,t_columnc,
t_dynastate n
WHERE tree.offspringid = t.columnid AND c.id = tree.parentid
AND tree.parentid in (6060,6200,6300,6400,6590,6600,6700,58701,59105,7100,7200,7300,7400,7500,6800,6900,7000,607)
andt.title like ('%北京%') or like ('上海')
----- [上海,天津,香港,深圳。。。]
AND item.objid = t.id
AND item.objtype = 0 AND p.objtypeid = 100 AND p.direction = 0 AND p.needpay = 1 AND p.summarytype = 0 AND p.moneytypeid = 0
AND p.objid=item.id AND item.orderid=o.id
AND o.id=n.objid AND n.objtype=102 AND n.statetypeid=1 AND n.statevalueid!=1
GROUP BYt.title,c.outername,t.id,c.id
ORDER BY AMOUNT DESC) WHERE ROWNUM 0
|