Getting data for more than 1 categories in SQL Server -
There are some categories and its products but the products are used for other categories. For example, "Metal Handles" are categories and used for "metal handles", but it is used for "children's handles" as well
thanks
thanks
Div>
really understand Not coming that you really need three potential cases here:
Products and categories - Many for many relationships
In many relationships Solve many You need three tables for the field
/ P> Categories (ID, Category name) categorymap (cd, partoffcigb) product (id, product name, category id)
Comments
Post a Comment