| | |
|---|
| | | INNER JOIN pp.optimize_project AS op ON op.project_no = c.project_no |
|---|
| | | LEFT JOIN pp.flow_card fc ON c.process_id = fc.process_id and fc.technology_number=c.technology_number |
|---|
| | | LEFT JOIN sd.ORDER o ON o.order_id = c.order_id |
|---|
| | | LEFT JOIN sd.order_detail od ON c.order_id = od.order_id |
|---|
| | | LEFT JOIN sd.order_detail od ON fc.order_id = od.order_id |
|---|
| | | AND fc.order_number = od.order_number |
|---|
| | | left join |
|---|
| | | (select (@row_number := @row_number + 1) as id,process_id as process_id,technology_number as technology_number from (select process_id,technology_number from pp.flow_card tt where project_no =#{projectNo} group by process_id,technology_number) tt,(select @row_number := 0) as t) a |
|---|
| | | on a.process_id=c.process_id and a.technology_number=c.technology_number |
|---|
