SELECT book_data.isbn,
book_data.title,
sum(store_out.shuliang),
store_out.zhekou,
sum(dan_head.mayang),
sum(dan_head.shiyang)
FROM book_data,
dan_head,
store_out
WHERE
( store_out.dan_id = dan_head.dan_id ) and
( store_out.book_id = book_data.book_id )
and ( dan_type='L')
group by book_data.title,store_out.zhekou,book_data.isbn
book_data.title,
sum(store_out.shuliang),
store_out.zhekou,
sum(dan_head.mayang),
sum(dan_head.shiyang)
FROM book_data,
dan_head,
store_out
WHERE
( store_out.dan_id = dan_head.dan_id ) and
( store_out.book_id = book_data.book_id )
and ( dan_type='L')
group by book_data.title,store_out.zhekou,book_data.isbn
解决方案 »
- 一个简单的sql语句
- 刚才说的分组问题不清楚,已整理好:
- 求有关UNION的用法????
- 请大家帮助解决我的很困惑的问题--关于联机帮助的一句话,搭救2个已经晕菜的可怜人,谢谢:-)
- 急!!在SQL Server中有没有把二进制数转化为16进制数的字符串的函数,或者通过脚本怎么处理?多谢,多谢!!
- 该语句如何优化?
- 用邹建局域网数据同步的程序,报错!数据库是7.O
- 谁来帮我解释一下!
- 在SQL Server2000中,以前建的一个数据库,怎样在重装SQL Server2000后重新挂到服务器中?
- 求一个sql的替换函数
- 刚碰到的datetime转换问题
- 谁知道哪里有微软SQL的查询分析器下载?我刚下了一个MSDE,安装后才知道什么都没有!
book_data.title,
sum(store_out.shuliang),
store_out.zhekou,
sum(dan_head.mayang),
sum(dan_head.shiyang)
FROM book_data,
dan_head,
store_out
WHERE
( store_out.dan_id = dan_head.dan_id ) and
( store_out.book_id = book_data.book_id )
and ( dan_type='L')
group by book_data.title,store_out.zhekou
a.title,
sum(c.shuliang),
c.zhekou,
sum(b.mayang),
sum(b.shiyang)
FROM book_data a,
dan_head b,
store_out c
WHERE
( c.dan_id = b.dan_id ) and
( c.book_id = a.book_id )
and ( dan_type='L')
group by a.isbn,title,c.zhekou