Need to create Bucket based on Group

Hi Experts,   I have two tables (Table 1 and Table 2 in my data model and is joined by Surid). I want to vloop (if Surid from table 2 exist in Surid1 from Table1 then fetch SURID,Gender,Studying,fi...