Hi there,

I have Page that goes to "sub categorys", but each time I upload a new product the subcategory gets duplicated each time, instead of having one "Vintage" category as I want I have duplicates.

My current SQL query string is

SELECT DISTINCT Picture, SubCategory, Categorie FROM Table1 WHERE (Categorie = ?)"

The distinct doesn't filter out duplicates.

DISTINCT will remove duplicates, but only if the fields you select from are all duplicates.

You have three fields here. Look at the results...is the info in the three fields identical?