# Strange problem with query

**URL:** <https://www.ruby-forum.com/t/strange-problem-with-query/181217>\
**Category:** Rails\
**Created:** [January 7, 2010, 1:39pm UTC](https://www.ruby-forum.com/t/strange-problem-with-query/181217 "2010-01-07T13:39:06Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![rafaelrosafu](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/59ef9b/32.png) [@rafaelrosafu](https://www.ruby-forum.com/u/rafaelrosafu)\
**Post date:** [January 7, 2010, 1:39pm UTC](https://www.ruby-forum.com/t/strange-problem-with-query/181217/1 "2010-01-07T13:39:06Z")

</div>

Hi all,  
suppose I have the following model:  
class FrotaEmpresa \< ActiveRecord::Base  
belongs\_to :servico, :foreign\_key=\>‘sev\_codigo’  
belongs\_to :tipo\_veiculo, :foreign\_key=\>‘tve\_codigo’  
end

in my controller I’m building a query like this:

select = “fro\_codigo, f.for\_cod, fro\_num\_ordem, fro\_placa,  
fro\_num\_sentados, fro\_num\_pe, fro\_data\_vistoria,  
fro\_chassi, fro\_ano\_chassi, fro\_ano\_fabricacao, fro\_situacao,  
tb\_fro\_frota\_onibus.created\_at,  
for\_num\_transportadora, for\_cnpj, for\_razao\_social, for\_logradouro,  
for\_bairro, for\_cidade, for\_uf, for\_cep, sv.sev\_codigo,  
sv.sev\_descricao, mar\_descricao,  
moc\_descricao, tic\_descricao, tve\_descricao, mcc\_descricao,  
tcc\_descricao”

joins =[" inner join TB\_SEV\_SERVICO\_VEICULO SV on SV.SEV\_CODIGO =  
TB\_FRO\_FROTA\_ONIBUS.SEV\_CODIGO" +  
" inner join TB\_TVE\_TIPO\_VEICULO TV on  
TB\_FRO\_FROTA\_ONIBUS.TVE\_CODIGO = TV.TVE\_CODIGO" +]

conditions = “fro\_situacao\<\>0”

FrotaEmpresa.find(:all,  
:select =\> select,  
:joins =\> joins,  
:conditions =\> conditions,  
:order=\>“tb\_fro\_frota\_onibus.for\_cod, fro\_num\_ordem”)

Strangely,my find method executes a “select \* from” in the  
“FrotaEmpresa” table for  
each “FrotaEmpresa” returned in the query which contains the joins. How  
can I solve this?  
Regards,  
Rafael R.