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 |
|
kray257
Starting Member
5 Posts |
 Posted - 2001-09-12 : 13:50:23
|
| Hi, Can anyone tell me how I would do this?I need to retrieve fields from a table called Prospects, such as name, address, etc...Along with that, there is another table (Calls) which contains call data for that person. Each person can have multiple calls logged, but I want to retrieve the status code (Status) from the calls table which is the most recent based on the date in the calls table.... (each entry in the calls table has a date/time field)I cannot figure out how to do it...Thanks.Kenny |
|
|
|
|
|
Need to retrieve TOP 1 from a second table...