Displaying 1 result from an estimated 1 matches for "shop_uri".
2006 Jul 15
1
Relationship problem, newbie problem, need help!!
...h my relationship between a few
tables...
If i then run the following query in mysql, i get the data i want. How
do i do this in rails relationships and models?
select * from shop_addresses
left join shops on shops.id = shop_addresses.shop_id
left join styles on styles.id = shops.style_id
where shop_uri = ''127.0.0.1''
Cheers!!
Tim Perrett
PS: The tables are the following...
#----------------------------
# Table structure for styles
#----------------------------
CREATE TABLE `styles` (
`id` int(11) NOT NULL auto_increment,
`css_file` text,
`asset_path` text,
PRIMARY KEY...