Extract entries related to another Internal table

Hi Experts,

from one table A(PA0001) ,i need to extract organization i.e. 'orgeh' into internal table X where some condition.

From second table B (HRP1001),i need to extract coursetype i.e. objid into internal table Y....where..??

My questin is that.... i need to have only those entries in the internal table Y which are related to internal table X only.

Please tell me the query for that.?

Sachin