select hiercode, code, hierindent(name[1],hiercode, false) from infrastructure_types where not del order by hiersort(hiercode)
Semen Collection Centres
Abattoirs
Veterinary Service Offices
Laboratories
Check points
Market PSR
Aggregation Centre
select hiercode, code, hierindent(name[1],hiercode, false) from infrastructure_types where not del order by hiersort(hiercode)
Semen Collection Centres
Abattoirs
Veterinary Service Offices
Laboratories
Check points
Market PSR
Aggregation Centre