# Doubt in retrievind data from habtm?

**URL:** <https://www.ruby-forum.com/t/doubt-in-retrievind-data-from-habtm/173236>\
**Category:** Rails\
**Created:** [August 5, 2009, 1:11pm UTC](https://www.ruby-forum.com/t/doubt-in-retrievind-data-from-habtm/173236 "2009-08-05T13:11:13Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![karthik](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/9fc348/32.png) [@karthik](https://www.ruby-forum.com/u/karthik)\
**Post date:** [August 5, 2009, 1:11pm UTC](https://www.ruby-forum.com/t/doubt-in-retrievind-data-from-habtm/173236/1 "2009-08-05T13:11:13Z")

</div>

hi

I have one table called agencies\_contract  
i need to get data from this table

agency\_id contract\_id  
1 1

so i need to display agency\_id equivalent to 1 and contract\_id  
equivalent to  
1

this table has habtm relation

how do i need to write query for this

any idea

Plz help

–  
Karthik.k  
Mobile - +91-9894991640