Select   '</br>'|| g.SDescription || '</br><b>'|| m.SDescription || '</b> -&gt;' || '<a href="Image/'  || m.SORGFILENAME || '" target="blank">' || 
m.SORGFILENAME || '</a>'  

LINE from multimedia m join groups g on g.WGroupid = m.Wrefid
where m.STYPE ='GROUP' and 
m.WRefId in (Select WGroupid FROM DOWNLOADS where wStockid =  <@WSTOCKID@>)