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.?