how to write subqueries in MDX

In SQL it would be something like this


CREATE PROCEDURE sp_proc
@param1 varchar(55)
as

Select id,name from table1
where id in(
SELECT distinct e_id
FROM table2
WHERE field=@param1)
go

HOW TO IMPLEMENT THIS FUNCTIONALITY IN MDX
please help. URRRGENT