Before a factory to production schedule, need to do the production plan details the following sorting processing
Step 1: (1) according to the first plastic department, plastic department of the same or similar plastic department comes together;
(2) step 2: according to the formula, the formula of the same or similar formula together,
Mainly glue is similar and similar formula is the string, use a comma as a separate
Name is close to the adhesive is a similar formula formula
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
T3603L - 25 AD AA AD03
T3603L - 25 b AD AA AD03
T3620 EX - A, B, D, AA, AD, AE A08
T4901 - EX AD AA AD01
T5101 - EX AA AD AA01
T7503 - EX AD AA AD03
Don't know how to handle the SQL code to reach the effect as shown in the figure below (red digital is order) :
