Hi Will,

Yes, this will work. You'll be prompted for the parameter value when you try to execute either the outer or inner query. You don't have to define the parameter in the outer query.

Thanks,
Josh