Query Assistance Needed - Please

[Andrew Tatum]

Alright, I have this table called Tags. The three columns of interest
are Tags.Id, Tags.Name, Tags.ParentTagId

This is the query I am currently using:

Select Tags.Id, Tags.Name, Tags.ParentTagId

>From Tags

WHERE Tags.Id IN (
22536,
22535
)

This outputs to:

Id Name ParentTagId
----- ------------ --------------
22535 Courses 148
22536 AEB3300-2204 22535

Obviously, Courses is the Parent Tag Name to AEB3300-2204. How can I
get this to show up so the results are something like

Alright, I have this table called Tags. The three columns of interest
are Tags.Id, Tags.Name, Tags.ParentTagId

This is the query I am currently using:

Select Tags.Id, Tags.Name, Tags.ParentTagId

>From Tags

WHERE Tags.Id IN (
22536,
22535
)

This outputs to:

Id Name ParentTagId ParentTagName
----- ------------ --------------
--------------
22535 Courses 148 SomeName
22536 AEB3300-2204 22535 Courses

Thank you all for your help! I truly appreciate it!

[Andrew Tatum]

Sorry about the above. I copied it to verify spelling, etc and
apparently instead of replacing the text it posted below it. I
apologize!