...
Code Block | ||
---|---|---|
| ||
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 |