Displaying 1 result from an estimated 1 matches for "store_nam".
Did you mean:
store_name
2006 Jul 31
1
How to get result of following SQL Query in Ruby?
Hi,
I have 2 tables as follows:-
_________________ ________________ ____________
taggings | |stores | | tags |
-----------------| |---------------| |------------|
--tag_id | |--store_id | |tag_id |
--store_id | |--store_name | |tag_name |
--user_id | |---------------| |------------|
-----------------|
Now I want to execute followin sql query on above tables:-
"select name from tags where tag_id in (select tag_id from taggings
where store_id in (select store_id from stores where citylist like
'...