select report_date,initcap(rsrc.name),initcap(title),initcap(recommendation), target_price,target_date,rfor.name,rmas.fname from broker_rep_mas rmas, broker_rep_trans rtrans, res_sourcemas rsrc,report_format_mas rfor,broker_recommendation recm where rtrans.sc_id='DSQ' and rtrans.fname=rmas.fname and rsrc.code=rmas.research_source and rmas.report_format=rfor.code and rtrans.recommendation=recm.code /