sql="SELECT DISTINCT c.*,round(AVG(d.avgprice)) avgprice
from `member_company` `c`,`yp_dp` `d`,`yp_relation` `r`
WHERE c.userid = d.userid = r.userid
GROUP BY c.userid DESC"
round(AVG(d.avgprice)) avgprice Õâ¸öÊÇÇ󯽾ù¼Û¸ñ£¬ÎÒÏë°´ÕÕÆ½¾ù¼Û¸ñ½µÐòÅÅÁУ¬ÊÇgroup by ---º ......
ÔÚACCESSÖеIJéѯÓï¾äSELECT ygname, ygcl.cpid, ygcl.cpname, cpxx.cpprice, sum(iif(val(jh)=3,0,iif(left(ygcl.bzcode,2)='04' or left(ygcl.bzcode,2)='05',round(val(cl)/val(zxs)*val(xs)*val(cpxx.cpprice),2),iif(val(cl)=0,round(val(cpxx.cpprice)*val(xs),2),round(val(cl)*val(xs)*val(cpxx.cp ......
´ó¼ÒºÃ£¬ÎÒÃÇĿǰÔÚ°ïCOREL¹«Ë¾¼±Æ¸SQL SERVER ADMINISTRATOR,ÒªÇóÓ¢Óï¿ÚÓïÊìÁ·£¬Ð½×ʾßÌåÃæÒé
ÒÔÏÂÊÇJD,ÇëÓÐÐËȤµÄÅóÓÑ£¬¼°Ê±ºÍÎÒÁªÏµ£¡MSN: Leon0294@hotmail.com
Company: Corel(www.corel.com.cn)
Position: Microsoft SQL Administrator
Job Description:
Corel is currently ......
date id
2009-12-01 ST0000000000000
2009-12-07 ST0000000000000
2009-12-01 ST0000000000001 ......
±íÒ» admin
uid uname
1 aaa
2 bbb
±í¶þ user
uid uname
1 ccc
2 ddd
±íÈý msg
id fromid fromUerType toid toUserType
1 1 1 2 1
2 1 1 &nb ......
Êý¾Ý¿âÖмǼÊÇÕâÑùµÄ£º
µØÇø ÆÀ¼ÛÄÚÈÝ ºÃÆÀ£¨Y£©
½ËÕ ¡£¡£ Y
½ËÕ ¡£¡£ N
½ËÕ ¡£¡£ Y
ɽ¶« &nbs ......