怎样可以使控件Query或者控件Table中的数据,按自身的字段任意排序 请帮忙 !!!
无奈在sql里排序吧 还是不行,请看下列语句:SELECT shangpinruku.shangpinpinzhong, SUM(shangpinxiaoshou.shishoujia)
AS xiaoshoue, SUM(shangpinxiaoshou.shishoujia) -
SUM (angpinruku.jinhuojiage) AS lirun
FROM shangpinruku INNER JOIN rukuchima ON shangpinruku.shangpinrukuid = rukuchima.shangpinrukuid INNER JOIN shangpinxiaoshou ON rukuchima.tiaoma = shangpinxiaoshou.shangpinbianhao
WHERE (shangpinxiaoshou.xiaoshoushijian >= '2001-01-01')
GROUP BY shangpinruku.shangpinpinzhong
ORDER BY xiaoshoue DESC在这条sql语句中 我希望给新产生的字段xiaoshoue 排序可怎么也通不过,如何解决?? SELECT shangpinruku.shangpinpinzhong, SUM(shangpinxiaoshou.shishoujia)
AS xiaoshoue, SUM(shangpinxiaoshou.shishoujia) -
SUM(shangpinruku.jinhuojiage) AS lirun
FROM shangpinruku INNER JOIN rukuchima ON shangpinruku.shangpinrukuid = rukuchima.shangpinrukuid INNER JOIN shangpinxiaoshou ON rukuchima.tiaoma = shangpinxiaoshou.shangpinbianhao
WHERE (shangpinxiaoshou.xiaoshoushijian >= '2001-01-01')
GROUP BY shangpinruku.shangpinpinzhong
ORDER BY SUM(shangpinxiaoshou.shishoujia) DESC这样做了也不行
无奈在sql里排序吧 还是不行,请看下列语句:SELECT shangpinruku.shangpinpinzhong, SUM(shangpinxiaoshou.shishoujia)
AS xiaoshoue, SUM(shangpinxiaoshou.shishoujia) -
SUM (angpinruku.jinhuojiage) AS lirun
FROM shangpinruku INNER JOIN rukuchima ON shangpinruku.shangpinrukuid = rukuchima.shangpinrukuid INNER JOIN shangpinxiaoshou ON rukuchima.tiaoma = shangpinxiaoshou.shangpinbianhao
WHERE (shangpinxiaoshou.xiaoshoushijian >= '2001-01-01')
GROUP BY shangpinruku.shangpinpinzhong
ORDER BY xiaoshoue DESC在这条sql语句中 我希望给新产生的字段xiaoshoue 排序可怎么也通不过,如何解决?? SELECT shangpinruku.shangpinpinzhong, SUM(shangpinxiaoshou.shishoujia)
AS xiaoshoue, SUM(shangpinxiaoshou.shishoujia) -
SUM(shangpinruku.jinhuojiage) AS lirun
FROM shangpinruku INNER JOIN rukuchima ON shangpinruku.shangpinrukuid = rukuchima.shangpinrukuid INNER JOIN shangpinxiaoshou ON rukuchima.tiaoma = shangpinxiaoshou.shangpinbianhao
WHERE (shangpinxiaoshou.xiaoshoushijian >= '2001-01-01')
GROUP BY shangpinruku.shangpinpinzhong
ORDER BY SUM(shangpinxiaoshou.shishoujia) DESC这样做了也不行
WHERE (shangpinxiaoshou.xiaoshoushijian >= '2001-01-01') 改成下面的代码试试FROM shangpinruku , rukuchima , shangpinxiaoshou WHERE (shangpinxiaoshou.xiaoshoushijian >= '2001-01-01') and (shangpinruku.shangpinrukuid = rukuchima.shangpinrukuid) and (rukuchima.tiaoma = shangpinxiaoshou.shangpinbianhao)