To retrieve the data for particular id in mapping table

Hi,

I have one mapping table, which has three fields A,B & C. A is primary key , B is tracking id for C. In C we have multiple records. So i need to retrieve the C data for the particular B id. Please help me in how to query this scenario. 

Expecting to get the code of Query entity for above explained scenario.

Thanks.. 

  Discussion posts and replies are publicly visible