API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 25th, 2016
81
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.57 KB | None | 0 0
raw download clone embed print report
  1. select * from prod_eje where job = '16-GS133-42';
  2. +--------+-------------+-----+---------+--------+-----+-------------------------+--------+--------+---------+-------+---------+---------+------+
  3. | id | job | qty | partnum | partid | seq | description | weight | length | shipqty | sheet | checked | loadnum | due |
  4. +--------+-------------+-----+---------+--------+-----+-------------------------+--------+--------+---------+-------+---------+---------+------+
  5. | 554087 | 16-GS133-42 | 10 | SL3 | PL | 1 | FB5/8X10 -7/8X1.13FT | 195.95 | 216 | 0 | 0 | 0 | 1 | NULL |
  6. | 554086 | 16-GS133-42 | 2 | SL2 | PL | 1 | FB5/8X12X1.46FT | 247.64 | 280 | 0 | 0 | 0 | 1 | NULL |
  7. | 554085 | 16-GS133-42 | 1 | SL1 | PL | 1 | FB5/8X10 -7/8X1.46FT | 203.82 | 280 | 0 | 0 | 0 | 1 | NULL |
  8. | 554084 | 16-GS133-42 | 1 | LP7 | PL | 1 | FB1/4X17X1.67FT | 24.81 | 320 | 0 | 0 | 0 | 1 | NULL |
  9. | 554083 | 16-GS133-42 | 1 | LP6 | PL | 1 | FB1/4X18X1.50FT | 22.97 | 288 | 0 | 0 | 0 | 1 | NULL |
  10. | 554082 | 16-GS133-42 | 1 | LP5 | PL | 1 | FB1/4X13X1.50FT | 17.23 | 288 | 0 | 0 | 0 | 1 | NULL |
  11. | 554081 | 16-GS133-42 | 34 | LP4 | PL | 1 | FB1/4X20X1.67FT | 28.36 | 320 | 0 | 0 | 0 | 1 | NULL |
  12. | 554080 | 16-GS133-42 | 6 | LP3 | PL | 1 | FB1/4X18X1.50FT | 22.97 | 288 | 0 | 0 | 0 | 1 | NULL |
  13. | 554079 | 16-GS133-42 | 7 | LP2 | PL | 1 | FB1/4X16X1.67FT | 22.69 | 320 | 0 | 0 | 0 | 1 | NULL |
  14. | 554078 | 16-GS133-42 | 20 | LP1 | PL | 1 | FB1/4X15X1.67FT | 21.98 | 320 | 0 | 0 | 0 | 1 | NULL |
  15. | 554077 | 16-GS133-42 | 4 | AB5 | R | 1 | ANCHOR ROD RB3/4X2.04FT | 3.26 | 392 | 0 | 0 | 0 | 1 | NULL |
  16. | 554088 | 16-GS133-42 | 4 | SL4 | B | 1 | FB5/8X6X1.07FT | 142.66 | 206 | 0 | 0 | 0 | 1 | NULL |
  17. | 554089 | 16-GS133-42 | 1 | SL5 | B | 1 | FB5/8X6X0.91FT | 115.15 | 174 | 0 | 0 | 0 | 1 | NULL |
  18. | 554090 | 16-GS133-42 | 16 | SL6 | B | 1 | FB5/8X6X1.07FT | 142.66 | 206 | 0 | 0 | 0 | 1 | NULL |
  19. | 554091 | 16-GS133-42 | 27 | SL7 | B | 1 | FB5/8X6X1.07FT | 168.19 | 206 | 0 | 0 | 0 | 1 | NULL |
  20. | 554092 | 16-GS133-42 | 6 | SL8 | B | 1 | FB5/8X6X0.91FT | 138.13 | 174 | 0 | 0 | 0 | 1 | NULL |
  21. | 554093 | 16-GS133-42 | 7 | SL9 | PL | 1 | FB5/8X6 -7/8X0.75FT | 99.42 | 144 | 0 | 0 | 0 | 1 | NULL |
  22. | 554094 | 16-GS133-42 | 4 | SL10 | PL | 1 | FB5/8X4 -7/8X0.75FT | 71.92 | 144 | 0 | 0 | 0 | 1 | NULL |
  23. +--------+-------------+-----+---------+--------+-----+-------------------------+--------+--------+---------+-------+---------+---------+------+
  24. 18 rows in set (0.00 sec)
  25.  
  26.  
  27. select * from compare_prod_eje where job = '16-GS133-42';
  28. +------+-------------+-----+---------+--------+-----+-----------------------+--------+--------+---------+-------+---------+---------+------+
  29. | id | job | qty | partnum | partid | seq | description | weight | length | shipqty | sheet | checked | loadnum | due |
  30. +------+-------------+-----+---------+--------+-----+-----------------------+--------+--------+---------+-------+---------+---------+------+
  31. | 4449 | 16-GS133-42 | 7 | LP2 | PL | 1 | FB1/4X16X1.67FT | 22.69 | 320 | 0 | 0 | 0 | 1 | NULL |
  32. | 4450 | 16-GS133-42 | 6 | LP3 | PL | 1 | FB1/4X18X1.50FT | 22.97 | 288 | 0 | 0 | 0 | 1 | NULL |
  33. | 4451 | 16-GS133-42 | 34 | LP4 | PL | 1 | FB1/4X20X1.67FT | 28.36 | 320 | 0 | 0 | 0 | 1 | NULL |
  34. | 4452 | 16-GS133-42 | 1 | LP5 | PL | 1 | FB1/4X13X1.50FT | 17.23 | 288 | 0 | 0 | 0 | 1 | NULL |
  35. | 4453 | 16-GS133-42 | 1 | LP6 | PL | 1 | FB1/4X18X1.50FT | 22.97 | 288 | 0 | 0 | 0 | 1 | NULL |
  36. | 4454 | 16-GS133-42 | 1 | LP7 | PL | 1 | FB1/4X17X1.67FT | 24.81 | 320 | 0 | 0 | 0 | 1 | NULL |
  37. | 4455 | 16-GS133-42 | 1 | SL1 | PL | 1 | FB5/8X10 -7/8X1.46FT | 203.82 | 280 | 0 | 0 | 0 | 1 | NULL |
  38. | 4456 | 16-GS133-42 | 2 | SL2 | PL | 1 | FB5/8X12X1.46FT | 247.64 | 280 | 0 | 0 | 0 | 1 | NULL |
  39. | 4457 | 16-GS133-42 | 10 | SL3 | PL | 1 | FB5/8X10 -7/8X1.13FT | 195.95 | 216 | 0 | 0 | 0 | 1 | NULL |
  40. | 4458 | 16-GS133-42 | 4 | SL4 | B | 1 | FB5/8X6X1.07FT | 142.66 | 206 | 0 | 0 | 0 | 1 | NULL |
  41. | 4459 | 16-GS133-42 | 1 | SL5 | B | 1 | FB5/8X6X0.91FT | 115.15 | 174 | 0 | 0 | 0 | 1 | NULL |
  42. | 4460 | 16-GS133-42 | 16 | SL6 | B | 1 | FB5/8X6X1.07FT | 142.66 | 206 | 0 | 0 | 0 | 1 | NULL |
  43. | 4461 | 16-GS133-42 | 27 | SL7 | B | 1 | FB5/8X6X1.07FT | 168.19 | 206 | 0 | 0 | 0 | 1 | NULL |
  44. | 4462 | 16-GS133-42 | 6 | SL8 | B | 1 | FB5/8X6X0.91FT | 138.13 | 174 | 0 | 0 | 0 | 1 | NULL |
  45. | 4463 | 16-GS133-42 | 7 | SL9 | PL | 1 | FB5/8X6 -7/8X0.75FT | 99.42 | 144 | 0 | 0 | 0 | 1 | NULL |
  46. | 4464 | 16-GS133-42 | 4 | SL10 | PL | 1 | FB5/8X4 -7/8X0.75FT | 71.92 | 144 | 0 | 0 | 0 | 1 | NULL |
  47. +------+-------------+-----+---------+--------+-----+-----------------------+--------+--------+---------+-------+---------+---------+------+
  48. 16 rows in set (0.00 sec)
  49.  
  50.  
  51. 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
  52.  
  53. 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
  54.  
  55. 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
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!