posted 11 years ago
I have 3 table C, S, R
1- C might have many S and vice versa
2- S might have many R and vice versa
3- R might have many C and vice versa
I have made a relation ship which produce three tables CS, SR and RC. This is will solve to get C list which has S. the Problem is how can I get let say S list with specific C and R. This is need another table CSR but how can I get it.
Please if you can post a sample with similar situation it will be so grateful