SELECT (case when parent.AL_DESCRIPTION LIKE '%新建%' then 'Y' else 'N' end) "MatchedNode",parent.AL_ITEM_ID, parent.AL_DESCRIPTION, parent.AL_FATHER_ID, parent.AL_ABSOLUTE_PATH FROM ALL_LISTS child join ALL_LISTS parent ON child.AL_ABSOLUTE_PATH LIKE parent.AL_ABSOLUTE_PATH+'%' WHERE parent.AL_ABSOLUTE_PATH LIKE 'AAAAAL%' AND child.AL_DESCRIPTION LIKE '%新建%'