Hey Santa,

Can you please validate the below code

SELECT Path,FolderName,FolderSize,FileName,FileSize

FROM

(

SELECT PATH,FolderName,FolderSize,'' AS FileName,'' AS FileSize, 1 AS ID FROM @Folders

UNION

select PATH,'' AS FolderName,'' as FolderSize,FileName, FileSize,2 AS ID from @Files

)E

ORDER BY PATH,ID