I've got a query that I just can't get right.
select *
>From companies
where companyhide = 0
and companyid = (select distinct companyid
From releases where date_entered <= DATE_SUB(curdate
(),INTERVAL 8 day) and date_entered >= DATE_SUB
(curdate(),INTERVAL 30 day)
order by date_entered desc)
order by rank, company
Essentially, I've got a table of companies and anothr table with press
releases. press releases are linked to companies by company id. What I'm trying
to do is select only companies that have press releases within the last for
weeks. What the above is giving me is a list of companuid's, whihc does not
work.
Any help or suggestion would be much appreciated.
-jeff
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208501
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
