• Post Reply Bookmark Topic Watch Topic
  • New Topic

Mapping many to many relationship between 3 tables

 
gaurav gupta sitm
Ranch Hand
Posts: 47
Java Redhat Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!