# Find and belongs\_to

**URL:** <https://www.ruby-forum.com/t/find-and-belongs-to/128605>\
**Category:** Rails\
**Created:** [February 9, 2008, 7:57am UTC](https://www.ruby-forum.com/t/find-and-belongs-to/128605 "2008-02-09T07:57:24Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sijo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/da6949/32.png) [@sijo](https://www.ruby-forum.com/u/sijo)\
**Post date:** [February 9, 2008, 7:57am UTC](https://www.ruby-forum.com/t/find-and-belongs-to/128605/1 "2008-02-09T07:57:24Z")

</div>

I have two tables

1)knowledge\_bases

id integer not null default  
nextval(‘public.knowledge\_bases\_id\_seq’::text)  
name character varying(200)  
keyword text  
url character varying(500)  
summary text  
details text

2)sd\_knowledge\_bases

id integer not null default  
nextval('public.service\_desk\_knowledge\_bases\_id\_seq  
'::text)  
sd\_id integer  
knowledge\_base\_id integer

In Sd  
has\_many :sd\_knowledge\_bases

In SdKnowledgeBase

belongs\_to :sd  
belongs\_to :knowledge\_base

For a given sd\_id in sd\_knowledge\_bases table how can i find all the  
fields from knowledge\_bases table  
Please help me

Sijo