I think I could pull this off if you show me how to separate the steps:

Do the first (inner) select into a cursor and then join with that cursor.

My bible for sQL was the FoxPro Programmers Reference and VFP 9's help.