How To Match Usernames From A SP?

Hello,

I am writing a SP, inside the SP i have a select statement.

I also have another SP, when i run it, it sends a list back with all the users that are currently online.

Now in my first SP, i want to construct a select statement that returns a users data, but only for the users that are online.

 

This is the first SP (GetAllOnlineUsers), that produces a list with users online (just abit rewritten from the membership function total users online):

SELECT u.Username FROM dbo.aspnet_Users u(NOLOCK), dbo.aspnet_Applications a(NOLOCK), dbo.aspnet_Membership m(NOLOCK) WHERE u.ApplicationId = a.ApplicationId AND LastActivityDate > @DateActive AND a.LoweredApplicationName = LOWER(@ApplicationName) AND u.UserId = m.UserId

 

This is my second SP, in witch i want to get the online users data:

SELECT m.username, d.data1, d.data2 FROM m.userstable INNER JOIN data ON (data.username = m.username) WHERE (m.username IN (EXEC GetAllOnlineUsers))

Is it possible to exec a SP into a select statement?