khoi01

eze3

Dec 7th, 2021
982
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT  INV_LOKASLAND, LOK_LOKASNAME
  2.     INV_POKOKCODE, POK_SAINTIFIK, POK_TEMPATANS,
  3.     INV_AGEGTREES,
  4.     INV_KOORDINAX,
  5.     INV_KOORDINAY
  6. FROM    SLAN.LAN_INVENTORI,
  7.     SLAN.LAN_POKOKCODE,
  8.     SLAN.LAN_LOKASCODE
  9. WHERE   INV_LOKASLAND = LOK_LOKASLAND
  10. AND     INV_POKOKCODE = POK_POKOKCODE
  11. AND     LOK_LOKASLAND IN ('JRDNS', 'JH', 'JSASS', 'JSIS')
  12.  
  13. SELECT  INV_AGEGTREES,
  14.     INV_LOKASLAND, LOK_LOKASNAME
  15.     INV_POKOKCODE, POK_SAINTIFIK, POK_TEMPATANS
  16.     INV_UKURLILIT,
  17.     INV_HIGHTREES,
  18.     INV_AGEGTREES,
  19.     INV_LEBARTREE,
  20.     INV_KOORDINAX,
  21.     INV_KOORDINAY
  22. FROM    SLAN.LAN_INVENTORI,
  23.     SLAN.LAN_POKOKCODE,
  24.     SLAN.LAN_LOKASCODE
  25. WHERE   INV_LOKASLAND = LOK_LOKASLAND
  26. AND     INV_POKOKCODE = POK_POKOKCODE
  27. AND INV_AGEGTREES > 5
  28.  
RAW Paste Data