SELECT "layer".*, "metadata".*, "layer"."idkategorisub" AS "idkategorisub", "layer"."idkategori" AS "idkategori"
FROM "layer"
LEFT JOIN "metadata" ON "layer"."idlayer" = "metadata"."idlayer"
WHERE "layer"."idkategorisub" IS NULL
ORDER BY "layer"."layer" ASC
Wargi Jabar - Detil Dataset
