/*
Alias: WORK
LiveAnswer: FALSE

*/

/*
Alias: WORK
LiveAnswer: FALSE

*/


select rubricatorid,snumb,rubricid, hostrubricid, nlevel, rubricstr
from   "L:\SOL\G\CIR_THES\rubrics\zm\org\rubrics.db"
where  nlevel=0
  and  rubricatorid = 9724
union
select rubricatorid,snumb,rubricid, hostrubricid, nlevel, '     '||rubricstr
from   "L:\SOL\G\CIR_THES\rubrics\zm\org\rubrics.db"
where  nlevel=1
  and  rubricatorid = 9724 
union
select rubricatorid,snumb,rubricid, hostrubricid, nlevel, '          '||rubricstr
from   "L:\SOL\G\CIR_THES\rubrics\zm\org\rubrics.db"
where  nlevel=2
  and  rubricatorid = 9724
  union
select rubricatorid,snumb,rubricid, hostrubricid, nlevel, '               '||rubricstr
from   "L:\SOL\G\CIR_THES\rubrics\zm\org\rubrics.db"
where  nlevel=3
  and  rubricatorid = 9724
union
select rubricatorid,snumb,rubricid, hostrubricid, nlevel, '                      '||rubricstr
from   "L:\SOL\G\CIR_THES\rubrics\zm\org\rubrics.db"
where  nlevel=4
  and  rubricatorid = 9724
union
select rubricatorid,snumb,rubricid, hostrubricid, nlevel, '                             '||rubricstr
from   "L:\SOL\G\CIR_THES\rubrics\zm\org\rubrics.db"
where  nlevel=5
  and  rubricatorid = 9724
order by snumb


