Nested SHAPE Help.

[Anchorman]

I'm using the following SHAPE command:

SHAPE {SELECT * FROM Chapters WHERE SchoolID=320}
APPEND ({SELECT * FROM ChapterLink}
RELATE ID TO ChapterID) AS Advisors
({SELECT FirstName, LastName FROM LocalAdvisors }
RELATE UserName TO UserName) AS AdvName

I get an error, "Column (UserName) does not exist in the appropriate
rowset", which is correct, the UserName column actually exists in the
ChapterLink table. But, I can't figure out how to construct this SHAPE
command so that it works like that. Could someone please help me out here?
I'm new to the Shape Command.
Thanks--Jesse