childID | Parent ID | Access Type | Roles 1 2 TAI Role Org eewr 3 4 KUU kjhtrtjl 2 5 TAI Role Org wewe 2 5 PTS kere 2 5 Mail Group qw 2 5 TAI Team erer 5 TAI team qw 5 Mail grop wieowej
Hi Guys,
From Above table, first i need to check childID which contains Access Type = TAI Role Org, and need to get parentId of those childID's and if those parentId comes under childid and contains access type = TAI*, we need those childID and Roles column.
Kindly someone help me to get data based on above criteria.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
.png "Former Employee"){kind=icon}
