# Ferret joins

**URL:** <https://www.ruby-forum.com/t/ferret-joins/159984>\
**Category:** Ferret\
**Created:** [February 10, 2009, 6:18pm UTC](https://www.ruby-forum.com/t/ferret-joins/159984 "2009-02-10T18:18:19Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![wesleyelder](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/c37758/32.png) [@wesleyelder](https://www.ruby-forum.com/u/wesleyelder)\
**Post date:** [February 10, 2009, 6:18pm UTC](https://www.ruby-forum.com/t/ferret-joins/159984/1 "2009-02-10T18:18:19Z")

</div>

Hey everyone,

just a quick question about ferret and joins.

i have two models

```auto
class Option < ActiveRecord::Base
  require 'acts_as_ferret'
  acts_as_ferret :fields => [:sym, :description, :opra_root]
end

and

class Sym < ActiveRecord::Base
  require 'acts_as_ferret'
  acts_as_ferret :fields => [:sym, :description], :ferret =>
{:max_clauses => 5000}
end
```

the sym model has many options.

So i just want to know if i can use :joins when calling

```auto
query = "y*"
options = Hash.new
      options[:select] = " options.opra_root, S.security_type, S.sym,
S.description as decs"
      options[:joins] = " as options INNER JOIN syms as S ON S.sym =
options.underlying_symbol"

Option.find_with_ferret(query, {}, options)
```

Currently total\_hits returns the correct value but length is always 0

Im very confused

Thanks  
Wes