Home > database >  A query query problem
A query query problem

Time:09-19

I have a table as shown below:
ProductBar for product coding, step for assembly sequence number, timeUsed for assembly unavailable,
Is a product must pass 1, 2, 3, 4 steps, in order to be assembled, as 2001000001 for success, 2001000002 for failure,
My question is:
1, how to use SQL statements out those encoding is successful and the general assembly unavailable;
2, the code is failure;

Thank you for your attention!

CodePudding user response:

Hope everybody to help, don't understand, .
  • Related