SQL Command - Group by command

See more:

SQL

Dear all,

I have table such as:

InVoice table
======
ID int
Date datetime
Money double


* Case A:
Select ID, Money
from InVoice
Group by ID
Having ID = 1

=> result is 1 row with ID = 1 and Money = xxx (OK)

* Case B:
Select ID, Money
from InVoice, Date
Group by ID, Date
Having ID = 1, Date between '2013/11/1' and '2013/11/10'
=> result is many row with ID = 1 and Money = xxx, yyy ...

I would in case B, result display 1 row, ID is 1 and Money is Total

Please help me
Thanks