select distinct r.*,c.city,c.state,c.country,c.metro_city,c.metro_state, c.business_type,b.budget_text,r.date_posted from rfq r inner join clients c on r.client_id = c.client_id inner join budget b on r.budget = b.budget_id where closing_date >= '#dateformat(Now(),"yyyy-mm-dd")#' and publish = 1 and status = 'A' and r.budget >= #b# and locale = 4 order by date_posted desc limit 100 Design and Development Projects Looking for Proposals http://www.designquote.net/rss/ #dateformat(Now(),"ddd")#, #dateformat(Now(),"d mmm yyyy")# 00:01:25 EST en-us http://www.designquote.net/RFQ/#rfq_id#.html http://www.designquote.net/RFQ/#rfq_id#.html #left(showdescr,200)#...<BR> Budget: #budget_text# <BR>Closes: #dateformat(closing_date,"mm/dd/yy")# <BR>Client Located: #city#, #state# <BR> #dateformat(date_posted,"ddd")#, #dateformat(date_posted,"d mmm yyyy")# #timeformat(NOW(),'hh:mm:ss')# GMT