Quote Originally Posted by DrByte View Post
Your duplicates are because you're joining multiple tables but not accounting for mismatched joins.
I built my suggestions based on you saying you wanted product_ids. Not complete product details. I assumed since you were only returning 1 item in your examples that you were intending to do a separate query for the rest of any truly needed data.
I understand, and THANK YOU for the help. I hope my previous reply didn't insinuate that your query was not what I has asked for. I simply used that as a "base" to modify and add more parameters to return fields from the database (like product name, image, etc). That was when I noticed it wasn't as easy as asking for those fields in the query.