select a.commo_no,sum(b.charge)
from sale_comm a,sale_master b
where a.exchange_no=b.exchange_no
and a.commo_no in (1000003916,1000019634,1000059906,1000028100,1000026625,1000026632,1000054970)
group by a.commo_no列出来的数据要按照in后面的顺序排列,怎么搞?
谢谢。
如果in后面的数据都是字符串型号的,就是加单引号的,又怎么做?
from sale_comm a,sale_master b
where a.exchange_no=b.exchange_no
and a.commo_no in (1000003916,1000019634,1000059906,1000028100,1000026625,1000026632,1000054970)
group by a.commo_no列出来的数据要按照in后面的顺序排列,怎么搞?
谢谢。
如果in后面的数据都是字符串型号的,就是加单引号的,又怎么做?
http://topic.csdn.net/u/20080717/15/53146890-6a89-4790-9bdd-ecb316e356ad.html?seed=1471448824
http://topic.csdn.net/u/20080721/12/c87d1a1d-b817-4de6-84ac-4f6ab56ef15a.html?seed=714459994#
可以看这两个贴子