Problem with duplicates in a SQL Join
- by Chris Ballance
I have the following result set from a join of three tables, an articles table, a products table, an articles to products mapping table.
I would like to have the results with duplicates removed similar to a select distinct on content id.
Current result set:
[ContendId] [Title] [productId]
1 article one 2
1 …