# Normalized table query not working now

**URL:** <https://www.ruby-forum.com/t/normalized-table-query-not-working-now/162685>\
**Category:** Rails\
**Created:** [March 12, 2009, 6:58pm UTC](https://www.ruby-forum.com/t/normalized-table-query-not-working-now/162685 "2009-03-12T18:58:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bigdaddy71](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/bbe5ce/32.png) [@bigdaddy71](https://www.ruby-forum.com/u/bigdaddy71)\
**Post date:** [March 12, 2009, 6:58pm UTC](https://www.ruby-forum.com/t/normalized-table-query-not-working-now/162685/1 "2009-03-12T18:58:08Z")

</div>

I have a Card table that previously had all of the data in it. I made  
a quite few tables and pulled the duplicated data into their own  
table.  
I was doing this:  
@cards = Card.find\_all\_by\_node\_id(@node.id, :conditions =\>  
[“HwDescription like ? OR HwDescription like ?”,"%OC%","%DS-1%"])

Now that is broken as the data is in a hwdescriptions table.

Any idea how to do this same query with a one-one relationship?

---

<div class="post-metadata">

**Author:** ![bigdaddy71](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/bbe5ce/32.png) [@bigdaddy71](https://www.ruby-forum.com/u/bigdaddy71)\
**Post date:** [March 13, 2009, 8:21am UTC](https://www.ruby-forum.com/t/normalized-table-query-not-working-now/162685/2 "2009-03-13T08:21:00Z")

</div>

take a look at the :include =\> :modelname option.
