Field Specific DISTINCT Statement
Im having a problem with displaying distinct records.
I have a posters db which contains serveral fields with categories, and sizes.
The problem is they all have a size, but may belong to 1 or more categories. Which is fine sorting by category but when they are view the products by their sizes it produces duplicates.
Is it posible to Use the DISTINCT on a specific field. In this case by product_name because it does not work just using the DISTINCT
HERE IS MY SQL Statement
strSQL = "SELECT DISTINCT product_id, product_type, product_size, product_code, product_name, product_cat FROM products ORDER BY product_name"