normalized table query not working now

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?

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