I want to join two tables and select columns from both tables, equivalent sql is as follows :
Using Rails 2.3.15
select p.id, p.title, p.img_url, p.url, pp.selling_price from products p inner join product_pricings pp on p.id = pp.product_id where p.is_best_selling_showcase = 1
What should be the equivalend ActiveRecord code for making this kind of joins. Any suggestions would help me lot.
Thanks in advance.