I have the following SQL to retrieve the parents of the groups with the ids (1300, 1200, 1000) specified below. Is there a way to inlude these ids in the output of the outer select statement? What is required is that the final output of the outer select contains "1300, 1200, 1000" as well.
The query is: