sql is select r.*, i.name, i.description, i.imageurl, t.description as "hardware_type", c.id as "company_id", c.name as "hardware_company_name" from hardware_reviews r, hardware_items i, hardware_companies c, hardware_types t where r.hardware_item_id = i.id and i.hardware_company_id = c.id and i.hardware_type_id = t.id and r.id = '29'
Not a member? Register here for free! It's quick and easy.