Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-15 : 10:03:45
|
| Rob writes "HiHere's my scenario:table1 (tblJob)CR identiferQuoteValue moneytable2 (tblTasks) (one to many relationship, many tasks)CR SchdStart datetimeSchdFinish datetimeActStart datetimeActFinish datetimeWhat i need is the SUM(QuoteValue) from tblJob between a specified date, the date will be the latest possible date from any of the associated tasks in table2 on any row. How would i accomplish this?Thanks in advance." |
|
|
|
|
|
Sql statement