select distinct a.ZMLI_BORROW_AMOUNT,a.INDEX_NUMBER,a.TITLE_200A,a.PUBLISHING,a.PUBLISH_DATE
from ZY_LITERATURE a
left join LG_LITERATURE_INFO b on a.id=b.LLIN_ZMLI_ID
left join LT_BORROW_RETURN_ALL c on b.LLIN_ID = c.LBRL_LLIN_ID where ZMLI_BORROW_AMOUNT = 10 这是我的sql ,我想查出的数据求和count,该怎么写
from ZY_LITERATURE a
left join LG_LITERATURE_INFO b on a.id=b.LLIN_ZMLI_ID
left join LT_BORROW_RETURN_ALL c on b.LLIN_ID = c.LBRL_LLIN_ID where ZMLI_BORROW_AMOUNT = 10 这是我的sql ,我想查出的数据求和count,该怎么写
解决方案 »
- JSON问题
- JBoss:javax.naming.NameNotFoundException: AccountBean not bound
- JSP的隐式对象有哪些?get和post提交的区别
- 困扰一下午的级联删除
- 关于Spring2.X中发送邮件的问题!!
- 紧急求助,Listener监听器问题
- ssh BeanNameAutoProxyCreator 事务代理配置出错!
- Tomcat5.0.28+JDK1.5.0_06+MySQL+Lomboz问题,请大家帮忙啊
- Tomcat5中关于 oracle驱动 classes12.jar 路径问题
- Java EJB 中的session Bean怎样来执行复杂的数据库操做
- 一对零或一的关系
- Struts2中采用那种页面框架集好, Tiles or FreeMarker?
from ZY_LITERATURE a
left join LG_LITERATURE_INFO b on a.id=b.LLIN_ZMLI_ID
left join LT_BORROW_RETURN_ALL c on b.LLIN_ID = c.LBRL_LLIN_ID where ZMLI_BORROW_AMOUNT = 10)