Guest yoruldum Posted November 28, 2003 Share Posted November 28, 2003 Hi there, I have a problem as you can imagine There is a table which has a list of products.For example we are buying product A from 3 suppliers and product B from 5 suppliers which of 2 suppliers are same. I want to have ability to search this table like \"SELECT * FROM products WHERE product_name = \'A\'\" and fetch suppliers name from that dataset. If I create one field called suppliers and add values like \"supp1,supp2,supp3\" than the result will be one string and I have to parse these one by one. Is there any easier way for that freaks Quote Link to comment Share on other sites More sharing options...
sirmanson Posted December 2, 2003 Share Posted December 2, 2003 You should probably create another table that just keeps track of which suppliers stock which products. Since you have a \"many-to-many\" relationship it should not be stored with your products. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.