hibernate - Join same table and fetch sub folders in mysql query -


I have a table to save "folders" in the document management system.

So I need to recover all folders ID from a folder id. E, the sub folders list of a folder.

Is it possible to join self in the same query?

try

  from the folders to choose d.folder_id d In, for folders e where d.parent_id = e.folder_id    

Comments

Popular posts from this blog

c - Performance of System() -

python - how we can use ajax() in views.py in django? -

python - Sequence Pattern recognition with Pybrain -