Search the Community
Showing results for tags 'mutiple sizes'.
I have gone through the book back to back and I found the tips and trciks very useful. However, I would like to develop further on the example give in the second site. I have a situation where a product has many sizes (different sizes with different stock values). The database structure and stored procedure described in the example is certainly not applicable here. I am thinking of creating a join table, removing the stock columm from the product table and add it to this join table but I am not sure how to write stored procedures that fetches same product, diffrent sizes and stock. I