Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from prod_eje where job = '16-GS133-42';
- +--------+-------------+-----+---------+--------+-----+-------------------------+--------+--------+---------+-------+---------+---------+------+
- | id | job | qty | partnum | partid | seq | description | weight | length | shipqty | sheet | checked | loadnum | due |
- +--------+-------------+-----+---------+--------+-----+-------------------------+--------+--------+---------+-------+---------+---------+------+
- | 554087 | 16-GS133-42 | 10 | SL3 | PL | 1 | FB5/8X10 -7/8X1.13FT | 195.95 | 216 | 0 | 0 | 0 | 1 | NULL |
- | 554086 | 16-GS133-42 | 2 | SL2 | PL | 1 | FB5/8X12X1.46FT | 247.64 | 280 | 0 | 0 | 0 | 1 | NULL |
- | 554085 | 16-GS133-42 | 1 | SL1 | PL | 1 | FB5/8X10 -7/8X1.46FT | 203.82 | 280 | 0 | 0 | 0 | 1 | NULL |
- | 554084 | 16-GS133-42 | 1 | LP7 | PL | 1 | FB1/4X17X1.67FT | 24.81 | 320 | 0 | 0 | 0 | 1 | NULL |
- | 554083 | 16-GS133-42 | 1 | LP6 | PL | 1 | FB1/4X18X1.50FT | 22.97 | 288 | 0 | 0 | 0 | 1 | NULL |
- | 554082 | 16-GS133-42 | 1 | LP5 | PL | 1 | FB1/4X13X1.50FT | 17.23 | 288 | 0 | 0 | 0 | 1 | NULL |
- | 554081 | 16-GS133-42 | 34 | LP4 | PL | 1 | FB1/4X20X1.67FT | 28.36 | 320 | 0 | 0 | 0 | 1 | NULL |
- | 554080 | 16-GS133-42 | 6 | LP3 | PL | 1 | FB1/4X18X1.50FT | 22.97 | 288 | 0 | 0 | 0 | 1 | NULL |
- | 554079 | 16-GS133-42 | 7 | LP2 | PL | 1 | FB1/4X16X1.67FT | 22.69 | 320 | 0 | 0 | 0 | 1 | NULL |
- | 554078 | 16-GS133-42 | 20 | LP1 | PL | 1 | FB1/4X15X1.67FT | 21.98 | 320 | 0 | 0 | 0 | 1 | NULL |
- | 554077 | 16-GS133-42 | 4 | AB5 | R | 1 | ANCHOR ROD RB3/4X2.04FT | 3.26 | 392 | 0 | 0 | 0 | 1 | NULL |
- | 554088 | 16-GS133-42 | 4 | SL4 | B | 1 | FB5/8X6X1.07FT | 142.66 | 206 | 0 | 0 | 0 | 1 | NULL |
- | 554089 | 16-GS133-42 | 1 | SL5 | B | 1 | FB5/8X6X0.91FT | 115.15 | 174 | 0 | 0 | 0 | 1 | NULL |
- | 554090 | 16-GS133-42 | 16 | SL6 | B | 1 | FB5/8X6X1.07FT | 142.66 | 206 | 0 | 0 | 0 | 1 | NULL |
- | 554091 | 16-GS133-42 | 27 | SL7 | B | 1 | FB5/8X6X1.07FT | 168.19 | 206 | 0 | 0 | 0 | 1 | NULL |
- | 554092 | 16-GS133-42 | 6 | SL8 | B | 1 | FB5/8X6X0.91FT | 138.13 | 174 | 0 | 0 | 0 | 1 | NULL |
- | 554093 | 16-GS133-42 | 7 | SL9 | PL | 1 | FB5/8X6 -7/8X0.75FT | 99.42 | 144 | 0 | 0 | 0 | 1 | NULL |
- | 554094 | 16-GS133-42 | 4 | SL10 | PL | 1 | FB5/8X4 -7/8X0.75FT | 71.92 | 144 | 0 | 0 | 0 | 1 | NULL |
- +--------+-------------+-----+---------+--------+-----+-------------------------+--------+--------+---------+-------+---------+---------+------+
- 18 rows in set (0.00 sec)
- select * from compare_prod_eje where job = '16-GS133-42';
- +------+-------------+-----+---------+--------+-----+-----------------------+--------+--------+---------+-------+---------+---------+------+
- | id | job | qty | partnum | partid | seq | description | weight | length | shipqty | sheet | checked | loadnum | due |
- +------+-------------+-----+---------+--------+-----+-----------------------+--------+--------+---------+-------+---------+---------+------+
- | 4449 | 16-GS133-42 | 7 | LP2 | PL | 1 | FB1/4X16X1.67FT | 22.69 | 320 | 0 | 0 | 0 | 1 | NULL |
- | 4450 | 16-GS133-42 | 6 | LP3 | PL | 1 | FB1/4X18X1.50FT | 22.97 | 288 | 0 | 0 | 0 | 1 | NULL |
- | 4451 | 16-GS133-42 | 34 | LP4 | PL | 1 | FB1/4X20X1.67FT | 28.36 | 320 | 0 | 0 | 0 | 1 | NULL |
- | 4452 | 16-GS133-42 | 1 | LP5 | PL | 1 | FB1/4X13X1.50FT | 17.23 | 288 | 0 | 0 | 0 | 1 | NULL |
- | 4453 | 16-GS133-42 | 1 | LP6 | PL | 1 | FB1/4X18X1.50FT | 22.97 | 288 | 0 | 0 | 0 | 1 | NULL |
- | 4454 | 16-GS133-42 | 1 | LP7 | PL | 1 | FB1/4X17X1.67FT | 24.81 | 320 | 0 | 0 | 0 | 1 | NULL |
- | 4455 | 16-GS133-42 | 1 | SL1 | PL | 1 | FB5/8X10 -7/8X1.46FT | 203.82 | 280 | 0 | 0 | 0 | 1 | NULL |
- | 4456 | 16-GS133-42 | 2 | SL2 | PL | 1 | FB5/8X12X1.46FT | 247.64 | 280 | 0 | 0 | 0 | 1 | NULL |
- | 4457 | 16-GS133-42 | 10 | SL3 | PL | 1 | FB5/8X10 -7/8X1.13FT | 195.95 | 216 | 0 | 0 | 0 | 1 | NULL |
- | 4458 | 16-GS133-42 | 4 | SL4 | B | 1 | FB5/8X6X1.07FT | 142.66 | 206 | 0 | 0 | 0 | 1 | NULL |
- | 4459 | 16-GS133-42 | 1 | SL5 | B | 1 | FB5/8X6X0.91FT | 115.15 | 174 | 0 | 0 | 0 | 1 | NULL |
- | 4460 | 16-GS133-42 | 16 | SL6 | B | 1 | FB5/8X6X1.07FT | 142.66 | 206 | 0 | 0 | 0 | 1 | NULL |
- | 4461 | 16-GS133-42 | 27 | SL7 | B | 1 | FB5/8X6X1.07FT | 168.19 | 206 | 0 | 0 | 0 | 1 | NULL |
- | 4462 | 16-GS133-42 | 6 | SL8 | B | 1 | FB5/8X6X0.91FT | 138.13 | 174 | 0 | 0 | 0 | 1 | NULL |
- | 4463 | 16-GS133-42 | 7 | SL9 | PL | 1 | FB5/8X6 -7/8X0.75FT | 99.42 | 144 | 0 | 0 | 0 | 1 | NULL |
- | 4464 | 16-GS133-42 | 4 | SL10 | PL | 1 | FB5/8X4 -7/8X0.75FT | 71.92 | 144 | 0 | 0 | 0 | 1 | NULL |
- +------+-------------+-----+---------+--------+-----+-----------------------+--------+--------+---------+-------+---------+---------+------+
- 16 rows in set (0.00 sec)
- Tried this: select prod_eje.* from prod_eje LEFT JOIN compare_prod_eje ON prod_eje.id = compare_prod_eje.id WHERE compare_prod_eje.id IS NULL; ## yields way too many results b/c there are other jobs in the DB
- Tried this: select prod_eje.* from prod_eje LEFT JOIN compare_prod_eje ON prod_eje.id = compare_prod_eje.id WHERE compare_prod_eje.id IS NULL and prod_eje.job = '16-GS133-42'; ## yields 18 rows
- I want to see 2 rows, partnum AB5 and LP1 ( the ones not in compare_prod_eje but are in prod_eje )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement