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 |
|
Theberge43
Starting Member
1 Post |
 Posted - 2006-12-13 : 10:19:33
|
| Hi,I have a datasheet created with an Access Query.It reads 2 identical table with to columns :Client # and Shipment #The result of the query is :Client A - Client B - Count of ShipmentThe problem I have is that for me the combinaisonsA - B & B - AAre the same ... is there a way to eliminate de duplicate rows ? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-13 : 10:38:03
|
| Yes there is!Show us the query. Post it here.Peter LarssonHelsingborg, Sweden |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-13 : 10:56:53
|
| Most likely you only have to add a WHERE statement of Col1 < Col2Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
Eliminate Duplicate Row A - B & B - A