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 |
|
cronincoder
Yak Posting Veteran
56 Posts |
 Posted - 2006-02-06 : 16:18:44
|
| I am designing a query using a 5 table JOIN. I am getting many duplicate results being returned. Not duplicate columns, but the results in the columns. Can anyone explain why this would be happening and what I can do to resolve it?thank youcc |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-02-06 : 17:38:02
|
| Because at least one of the joins you think is unique isn't.You're probably missing a join column.Restrict the results to one of sets of duplicates then do a select * instead of restricting the columns returned. The differences will should you which table is mising the join.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Help..duplicate results!