Hi,
Thank you for your information. Hmm,.. according to the sample data in previous message, it seem like you cant diffrentiate the modal of item?

E.g.

I have pants from couple of brands. How could I know the pant's qty of brand "A", with Size 32X32, and colour "DENIM"?

According to the table your post as below, I only able to know, pants which is "DENIM" in colour and Size 32X32, it's qty is 5. How about if I want know only the particular model or brand?

ItemID ClassID   Class Name   ColorID Color SizeID Size  Stock
1      1         SHIRT        1       BLUE  1      S     50
2      1         SHIRT        1       BLUE  2      M     25
3      1         SHIRT        2       RED   1      S     30
4      2         PANTS        5       DENIM 10     32X32 10
5      2         PANTS        5       DENIM 11     32X34 5   

Thank you