****how can hide repeated data from my view table. i want to print employee Id and name field only once for each group. can you please help me out.****
I am fetching two table in view using JOIN.So few data gets repeated with respect to foreign key. So I need to hide those field value... Suggest me any solution...distinct and aggregation mixing up my data..