# Multiple Table Query

**URL:** <https://www.ruby-forum.com/t/multiple-table-query/195149>\
**Category:** Rails\
**Created:** [September 17, 2010, 5:51pm UTC](https://www.ruby-forum.com/t/multiple-table-query/195149 "2010-09-17T17:51:14Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![PalaniKannan\_K](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/eb8c5e/32.png) [@PalaniKannan\_K](https://www.ruby-forum.com/u/PalaniKannan_K)\
**Post date:** [September 17, 2010, 5:51pm UTC](https://www.ruby-forum.com/t/multiple-table-query/195149/1 "2010-09-17T17:51:14Z")

</div>

Dear All,  
\*  
Inputs:\*  
Query 1 = column1.table1,  
Query2 = column2.table1  
column3.table1 = foreign\_key

using this two queries and foreign key (column3.table1), I have to print  
a  
column4.table2

_condition:_  
where column3.table1 = column3.table2

I need to print

_OUTPUT_  
column4.table2

Its simple in find\_by\_sql.

## I need in “find”. Please suggest me.

With Regards  
Palani Kannan. K  
Office: +49-531-2616-226  
Mobile: +4917647098166