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
Post a Comment