The problem is that I have two tables A and B,
A table is (id on the id primary key, product category, product quality standards for 1, 2) product quality standard
B table is put in storage table (id id primary key, product category, quantity, weight, product production quality 1, product quality 2)
Need to let the B table when the product classification and A table at the same time, A classification is phase 1 B table product quality compared to A table than product quality standard 1, 2, 2,
When B>=A table production quality 1 B table "product production quality 1" for the green, red is not the same
CodePudding user response:
Don't understand, the feeling is so complicated