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-05-16 : 06:47:36
|
| Shane writes "I'm running a query that has two columns for incident reporting. The first column is for the victim and the second is for the offender. Both come from two seperate tables on a left outer join through the incident info. Depending on the incident, there may be multiple victims or multiple offenders. For the result set, a victim's name or offender's name can only appear once per incident. Is this possible, and if so, how?" |
|
|
|
|
|
Suppressing Duplicated Records In A Query