Say, I have two tables (requirements & projreqs)and want to execute the
SELECT * FROM requirements WHERE(id = (SELECT req_id FROM projreqs WHERE
proj_id = ?));
Being a newbie in Ruby, I know only to extract data from one table.
Eg: Requirement.find(:all, :select, :condition) or
But, how to combine two tables? Please help me out…
Appreciate your help.