select '--' as LINK, o.BOID as BOID, o.BONAME as BONAME, o.BODESC as BODESC, 

           co.BOMTYP as CBOMTYP, co.BOID as CBOID, co.PARBOID as CPARBOID, CONCAT(o.PARBOID,'.',o.BOID) as BOPATH,

           co.BOTYPEID as CBOTYPEID, 

           co.BONAME as CBONAME, co.BODESC as CBODESC

  from BOBOBJS o

    left outer join BOBOBJS co on co.PARBOID=o.BOID

 where o.BOMTYP='BOBJ' and o.PARBOID=?