Retrieve data from SP inside of From
That is not a supported syntax as a stored procedure can return multiple result sets or do other data manipulations and return nothing.

You would need to convert your stored procedure to a table valued function or insert the results into a temp table.