# Rss feeds from two tables and to come on top the latest created in two tables

**URL:** <https://www.ruby-forum.com/t/rss-feeds-from-two-tables-and-to-come-on-top-the-latest-created-in-two-tables/186306>\
**Category:** Rails\
**Created:** [April 4, 2010, 9:09am UTC](https://www.ruby-forum.com/t/rss-feeds-from-two-tables-and-to-come-on-top-the-latest-created-in-two-tables/186306 "2010-04-04T09:09:39Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![rahul\_m](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/43a26b/32.png) [@rahul\_m](https://www.ruby-forum.com/u/rahul_m)\
**Post date:** [April 4, 2010, 9:09am UTC](https://www.ruby-forum.com/t/rss-feeds-from-two-tables-and-to-come-on-top-the-latest-created-in-two-tables/186306/1 "2010-04-04T09:09:39Z")

</div>

hii all

want to generate rss feeds from two tables and to come on top the  
latest created in two tables

1st table

create table  
CREATE TABLE `content_masters` (  
`id` int(11) NOT NULL auto\_increment,  
`image_path` varchar(255) collate utf8\_unicode\_ci default NULL,  
`content_text` text collate utf8\_unicode\_ci,  
`abstract_text` varchar(700) collate utf8\_unicode\_ci default NULL,  
`title` varchar(255) collate utf8\_unicode\_ci default NULL,  
`color` varchar(255) collate utf8\_unicode\_ci default NULL,  
`parent_id` int(11) default NULL,  
`promote` int(11) default ‘0’,  
`promote_block` varchar(255) collate utf8\_unicode\_ci default ‘N’,  
`draft_state` varchar(255) collate utf8\_unicode\_ci default ‘N’,  
`order_no_article` int(11) default NULL,  
`created_at` datetime default NULL,  
`updated_at` datetime default NULL,  
`photo_file_name` varchar(255) collate utf8\_unicode\_ci default NULL,  
`photo_content_type` varchar(255) collate utf8\_unicode\_ci default  
NULL,  
`photo_file_size` int(11) default NULL,  
`photo_updated_at` datetime default NULL,  
PRIMARY KEY (`id`)  
) ENGINE=InnoDB AUTO\_INCREMENT=29 DEFAULT CHARSET=utf8  
COLLATE=utf8\_unicode\_ci

create table  
CREATE TABLE `sub_content_masters` (  
`id` int(11) NOT NULL auto\_increment,  
`abstract_text` varchar(700) collate utf8\_unicode\_ci default NULL,  
`title` varchar(255) collate utf8\_unicode\_ci default NULL,  
`image_id` varchar(255) collate utf8\_unicode\_ci default NULL,  
`order_no` int(11) default NULL,  
`created_at` datetime default NULL,  
`updated_at` datetime default NULL,  
PRIMARY KEY (`id`)  
) ENGINE=InnoDB AUTO\_INCREMENT=4 DEFAULT CHARSET=utf8  
COLLATE=utf8\_unicode\_ci

## want to join these two table in query so that i got the latest created , title with abstract\_text

my xml code  
xml.instruct!

xml.rss “version” =\> “2.0”, “xmlns:dc” =\> “[http://purl.org/dc/elements/](http://purl.org/dc/elements/)  
1.1/” do  
xml.channel do

xml.title "Atlantis Software Articles "  
xml.link url\_for :only\_path =\> false, :controller =\>  
‘articles’  
xml.description “Atlantis Software Articles”

@articles.each do |article|  
xml.item do  
xml.title article.title  
xml.link (root\_url+article.title.gsub(/ /,‘-’).downcase)  
xml.description article.content\_text  
end  
end

@subcon.each do |article|  
xml.item do  
xml.title article.title  
xml.description article.abstract\_text  
end  
end

## end end

controller code  
def rss  
@articles = ContentMaster.find(:all, :order =\> “id DESC”)  
@subcon = SubContentMaster.find(:all, :order =\> “id DESC”)  
render :layout =\> false  
response.headers[“Content-Type”] = “application/xml;  
charset=utf-8”  
end

pls help…

thanks

rahul