Topic: get records from two tables

Hi, all

This is the first time I post here on rails forum.

Probably I approach this  from the wrong angel and that is the reason way I can't find a solution.
This must be a very common problem so I can't understand why I can't find any documentation or nothing about how do this.  Anyway this is the problem I having.

lets say i have one table containing :

5   dogs
2   cats

and another table containing:

2   dogs
1   cat
3   birds

then a user submits a form I want to be able to merge the data from this two tables
and return

7 dogs
3 cats
3 birds

In what way should  I approach this  ?

Hope you can help me in the right direction

Last edited by juppe (2011-04-23 00:10:11)