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 - 2002-02-08 : 15:55:55
|
ken writes "I am trying to create a SQL select statement from three tables and dump it into one new table using DTS. the tables are Customer, Appliance, Inspect. For each appliance record there are several inspection records. When I create the new table for my website database I only want to have one record per appliance using the newest inspection record by date. I'm stumped... The problem I'm having is using the newest inspection row for each appliance, if there are duplicates. help " |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
difficult multi table problem... 