The screen shot above shows that I am trying to reference one query table from another and getting the message "Unknown table or alias"

can you explain why this is and is there a workaround?

Trevor