posted 10 years ago
Notice that p.ProductCode is no longer unique, how do I identify each
Product separately?
Given that Texture has groups of Subtextures and
has to cross join with the product table so that
each combination of texture and subtexture has
its product in its type...
Update:
I thought, is that the way to go, concatenate each id from each table??...
Thanks
Update2:
The problem is I don't know how to define a unique price for each item
Jack