Query Trouble : SELECT a.docindex FROM docs a, editions b, data_2009 c, headers d WHERE a.editionindex = b.editionindex AND a.docindex = c.docindex AND c.headerindex = d.headerindex AND d.header = 'department' AND a.parsedate > 0 AND c.data = ' PATENT AND TRADEMARK OFFICE' ORDER BY b.date DESC
http://thefederalregister.com/b.p/department/_PATENT_AND_TRADEMARK_OFFICE/ Daily Publications of Meetings and Rules Changes for the Federal Government Thu, Jan 8 2009 11:00:00 GMT Thu, Jan 8 2009 11:00:00 GMT info@thefederalregister.com