Home > database >  Write SQL problem, please great god bother to look at, the shit out of me hard, online urgent solve!
Write SQL problem, please great god bother to look at, the shit out of me hard, online urgent solve!

Time:12-06

Table 1 (product process chart)
Product model process sequence number
P2548A0 flow 1 1
P2548A0 flow 2 2
P2548A0 process 3 3
P2548A0 flow 1 4
P2548A0 process 3 5
P2548A0 process 4 6
P2549A0 flow 1 1
P2549A0 process 3 2
P2549A0 process 5 3
P2549A0 process 6 4

Table 2 (product)
Serial number product model process product serial number online number
0001 P2548A0 process 1 1 10
0002 P2548A0 process 3 3 20
0003 P2548A0 process 3 5 30
0004 P2549A0 process 3 2 100
0005 P2549A0 process 6 4 50
0006 P2548A0 process 3 3 60
To achieve the results
A B C D E F G H...
P2548A0 flow 1 2 3 processes 1 processes 3 process 4
10 80 30
P2549A0 1 processes 3 5 processes 6
50 100

  • Related