search for: equipment_id

I am currently working on a small database project to track company assets. Right now my Database consists of 3 tables. 1 for the equipment, 1 for the users info, and 1 for the type of equipment. I have all 3 databases working on a model test site using RoR. Where i am having trouble is getting the databases to talk together. I can''t find this answer anywhere else. My main table

...the Oracle adapter and a find_by_sql call on a multi-table join. The SQL looks like this: SELECT DISTINCT e1.ip_address, loc.street, loc.city, loc.state FROM schema.net_element ne, schema.equipment e1, schema.equipment e2, schema.building b, schema.cust_loc cl, schema.location loc WHERE e2.equipment_id = e1.equipment_id AND e2.some_column like ''SOME_VAL%'' AND e1.equipment_id = ne.net_element_id AND ne.class_name = ''FooBar'' AND e1.building_id = b.building_id AND b.main_address = cl.cust_loc_id AND cl.location_id = loc.location_id So, I setup a class for the ...