# Query returning just one value **URL:** \ **Category:** Rails\ **Created:** [May 5, 2009, 10:24am UTC](https://www.ruby-forum.com/t/query-returning-just-one-value/167192 "2009-05-05T10:24:51Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![vapor](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/5e9695/32.png) [@vapor](https://www.ruby-forum.com/u/vapor)\ **Post date:** [May 5, 2009, 10:24am UTC](https://www.ruby-forum.com/t/query-returning-just-one-value/167192/1 "2009-05-05T10:24:51Z")
I am using INNER JOIN and it is supposed to return more than one results but it only returns first element. How do I get all elements in an array? Also, in the same query I am using another INNER JOIN that is supposed to return one value only which is does. Thanks. ---
**Author:** ![vapor](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/5e9695/32.png) [@vapor](https://www.ruby-forum.com/u/vapor)\ **Post date:** [May 5, 2009, 1:41pm UTC](https://www.ruby-forum.com/t/query-returning-just-one-value/167192/2 "2009-05-05T13:41:25Z")
It’s hard to help you if you don’t show any code. - Maurício Linhares [http://alinhavado.wordpress.com/](http://alinhavado.wordpress.com/) (pt-br) | [http://blog.codevader.com/](http://blog.codevader.com/) (en) On Tue, May 5, 2009 at 5:24 AM, Vapor … ---
**Author:** ![vapor](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/5e9695/32.png) [@vapor](https://www.ruby-forum.com/u/vapor)\ **Post date:** [May 5, 2009, 1:48pm UTC](https://www.ruby-forum.com/t/query-returning-just-one-value/167192/3 "2009-05-05T13:48:27Z")
Maurício Linhares wrote: > It’s hard to help you if you don’t show any code. @dest = Destination.find\_by\_id(params[:id], :joins =\> “INNER JOIN cities ON cities.id = city\_id INNER JOIN destination\_images ON destination\_images.destination\_id = destinations.id AND destination\_images.is\_primary\_photo = 1 INNER JOIN destination\_tags ON destination\_tags.destination\_id = destinations.id”, :select =\> ‘destinations.\*, cities.name as city\_name, destination\_images.url as image\_url, destination\_tags.tag\_id as tag\_id\_list’ ) pretty messy though! ---
**Author:** ![vapor](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/5e9695/32.png) [@vapor](https://www.ruby-forum.com/u/vapor)\ **Post date:** [May 5, 2009, 1:51pm UTC](https://www.ruby-forum.com/t/query-returning-just-one-value/167192/4 "2009-05-05T13:51:27Z")
Vapor … wrote: > Maurício Linhares wrote: > > > It’s hard to help you if you don’t show any code. > > @dest = Destination.find\_by\_id(params[:id], :joins =\> “INNER JOIN cities > ON cities.id = city\_id > INNER JOIN destination\_images ON destination\_images.destination\_id = > destinations.id AND destination\_images.is\_primary\_photo = 1 > INNER JOIN destination\_tags ON destination\_tags.destination\_id = > destinations.id”, > :select =\> ‘destinations.\*, cities.name as city\_name, > destination\_images.url as image\_url, destination\_tags.tag\_id as > tag\_id\_list’ ) tag\_id\_list is supposed to return an array ---
**Author:** ![vapor](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/5e9695/32.png) [@vapor](https://www.ruby-forum.com/u/vapor)\ **Post date:** [May 5, 2009, 1:59pm UTC](https://www.ruby-forum.com/t/query-returning-just-one-value/167192/5 "2009-05-05T13:59:26Z")
Maurício Linhares wrote: > This query is never going to return an array, it’s going o return a > single row (by the params[:id]) with the joined relations. Yeah, any help would be appreciated 🙂 ---
**Author:** ![vapor](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/5e9695/32.png) [@vapor](https://www.ruby-forum.com/u/vapor)\ **Post date:** [May 5, 2009, 1:57pm UTC](https://www.ruby-forum.com/t/query-returning-just-one-value/167192/6 "2009-05-05T13:57:18Z")
This query is never going to return an array, it’s going o return a single row (by the params[:id]) with the joined relations. - Maurício Linhares [http://alinhavado.wordpress.com/](http://alinhavado.wordpress.com/) (pt-br) | [http://blog.codevader.com/](http://blog.codevader.com/) (en) On Tue, May 5, 2009 at 8:51 AM, Vapor … ---
**Author:** ![vapor](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/5e9695/32.png) [@vapor](https://www.ruby-forum.com/u/vapor)\ **Post date:** [May 5, 2009, 3:02pm UTC](https://www.ruby-forum.com/t/query-returning-just-one-value/167192/7 "2009-05-05T15:02:35Z")
First you need to explain what you do want returned and your database structure. - Maurício Linhares [http://alinhavado.wordpress.com/](http://alinhavado.wordpress.com/) (pt-br) | [http://blog.codevader.com/](http://blog.codevader.com/) (en) On Tue, May 5, 2009 at 8:59 AM, Vapor …