To elaborate, I have products that can be in multiple categories, and I want to grab the category code out of the Product_Category relational table where the category code is the smallest. Thanks!
select where "conditions" AND code.length == small
Moderator: General Moderators
select where "conditions" AND code.length == small
I need to select from 3 tables where "some conditions" and table1.code is the least amount of characters. Is this possible?
To elaborate, I have products that can be in multiple categories, and I want to grab the category code out of the Product_Category relational table where the category code is the smallest. Thanks!
To elaborate, I have products that can be in multiple categories, and I want to grab the category code out of the Product_Category relational table where the category code is the smallest. Thanks!