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 - Mpirun hangs when mpi send and recieve is put in a loop -

python - Apply coupon to a customer's subscription based on non-stripe related actions on the site -

java - Unable to get JDBC connection in Spring application to MySQL -