| | |
|---|
| | | select a.process from sd.order_process_detail as a, |
|---|
| | | (select id,process from sd.order_process_detail |
|---|
| | | where process_id=#{processId} |
|---|
| | | and technology_number=#{technologyNumber} |
|---|
| | | and position(technology_number in #{technologyNumber}) |
|---|
| | | and order_number=#{orderNumber} |
|---|
| | | and process=#{thisProcess} |
|---|
| | | group by process) as b |
|---|
| | | where a.id = b.id + 1 |
|---|
| | | and a.process_id=#{processId} |
|---|
| | | and a.order_number=#{orderNumber} |
|---|
| | | and a.technology_number=#{technologyNumber} |
|---|
| | | and position(a.technology_number in #{technologyNumber}) |
|---|
| | | |
|---|
| | | </select> |
|---|
| | | |
|---|
