Kindly help me
I am having a table production which table consists productname, item_code,qty and approx 1000 records in that
there are three type of product_id
p1,p2, p3 ....to p300 product_id is for production consumable
m1, m2,m3 .....to m700 product_id is for maintenance consumable
rest...