eze3

SELECT  INV_LOKASLAND, LOK_LOKASNAME
    INV_POKOKCODE, POK_SAINTIFIK, POK_TEMPATANS,
    INV_AGEGTREES,
    INV_KOORDINAX,
    INV_KOORDINAY
FROM    SLAN.LAN_INVENTORI,
    SLAN.LAN_POKOKCODE,
    SLAN.LAN_LOKASCODE
WHERE   INV_LOKASLAND = LOK_LOKASLAND
AND     INV_POKOKCODE = POK_POKOKCODE
AND     LOK_LOKASLAND IN ('JRDNS', 'JH', 'JSASS', 'JSIS')

SELECT  INV_AGEGTREES,
    INV_LOKASLAND, LOK_LOKASNAME
    INV_POKOKCODE, POK_SAINTIFIK, POK_TEMPATANS
    INV_UKURLILIT,
    INV_HIGHTREES,
    INV_AGEGTREES,
    INV_LEBARTREE,
    INV_KOORDINAX,
    INV_KOORDINAY
FROM    SLAN.LAN_INVENTORI,
    SLAN.LAN_POKOKCODE,
    SLAN.LAN_LOKASCODE
WHERE   INV_LOKASLAND = LOK_LOKASLAND
AND     INV_POKOKCODE = POK_POKOKCODE
AND INV_AGEGTREES > 5