[2005] select subquery

[jlbantang]

hi i created a simple subquery but im getting an execution error.

select parentID,childID, nodedescription
  (select nodedescription from tblMyTable order by nodedescription)
from tblMyTable
order by parentID