Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
SELECT 
  tbltag.strVlanId ID,
  tbltag.strName VLAN,
  tbltag.strDescription Description,
  tbltaggroup.strName || '/' || tbltaggroup.intCIDR Subnet
FROM
  tbltag
LEFT JOIN tbltaggroup
ON
  tbltag.intId_pk = tbltaggroup.intVlanId_fk
WHERE
  tbltag.strClassName = "'TBoNisTagVLAN"'
ORDER BY ID ASC