I have to tables as parent & child tables as below
Table 1
TID1 Name
1 Test1
2 Test2
3 Test3
Table2
TID2 || TID1 || ID1 || ID2 || ID3 || Name
1 1 1 2 3 All
2 2 2 2 2 All2
3 1 1 1 12 Jack
4 2 3 4 12 Jim
5 3 31 4 12 Jim
can some body help me as how can i fetch the all TID1's if pass the list of ID1's string , to a SP