select * from tblNewsLetterArticle where NewsletterID = #url.NewsLetterID# select * from tblNewsLetterArticle where NewsletterID = #url.NewsLetterID# and status=1 Select tblmediafiles.MFName, trelNewsLettermedia.Med_Order, tblmediafiles.Image, tblmediafiles.Op_Image, tblmediafiles.Html, tblmediafiles.type, tblmediafiles.MFLink from tblmediaFiles, trelNewsLettermedia, tblNewsLetterArticle where tblNewsLetterArticle.NewsLetterID = #url.NewsLetterID# and trelNewsLettermedia.NewsLetterID=tblNewsLetterArticle.NewsLetterID and tblmediafiles.mediaid = trelNewsLettermedia.mediaid and (trelNewsLettermedia.EXP_DATE >= #CreateODBCDate(Now())# or trelNewsLettermedia.EXP_DATE is null) order by trelNewsLettermedia.med_order

#body#   #MediaArray[count][2]##MediaArray[count][1]#