Multiple Table Query

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.