b 中在2008-5月之间有多条数据。其实只要保证a表中Travel_Number在范围内就行。 Select (Sum(a.Plan_Income) - Sum(a.Received_Money)) From Treval_Sale_Income as a where Travel_Number IN (select Travel_Number from Travel_Group as b where Year(b.Start_Out_Time)=2008 and Month(b.Start_Out_Time)=5) --优化语句,换成 --where b.Start_Out_Time> '2008-05-01' and b.Start_Out_Time< '2008-05-31') and a.UserName = 'sale6'
所以翻倍
那这个问题应该怎么搞,要实现按Start_Out_Time来查询,还有别的办法吗?
[align=center]==== 思想重于技巧 ====
[/align]
谢谢大家~!
a.Travel_Number = b.Travel_Number
b表的字段travel_number可能有多个重复值.
Select (Sum(a.Plan_Income) - Sum(a.Received_Money))
From Treval_Sale_Income as a
where Travel_Number IN (select Travel_Number from Travel_Group as b
where Year(b.Start_Out_Time)=2008 and Month(b.Start_Out_Time)=5)
--优化语句,换成
--where b.Start_Out_Time> '2008-05-01' and b.Start_Out_Time< '2008-05-31')
and a.UserName = 'sale6'