mysql数据库中的多表联查
在项目中遇见了mysql库的多表联查,记录下来,供以后查阅。
select a.slzgh as Zgh,c.username as Xm,a.slksh as Ksh,d.Ksmc,a.Ffdate,b.Sortid,b.Sortname,sum(b.Silnum) as Silnum
from offmate a
inner join offmatedetail b on a.c...
原创
2010-12-19 09:32:46 ·
243 阅读 ·
0 评论