declare @ffdate datetime
declare @fedate datetime

select f.fna,f.ffjlx,f.fsyjx,
				(case 
					when x.fgt is null then '零售'
					when x.fgt is not null then (select fna from tgt where tgt.fid=x.fgt)
				end
						) as fgtname,x.fdate,
	y.fname,l.fname as fxlx,x.fnum,x.fmon,r.fmon as fjhmon,x.fnum*(x.fmon-r.fmon) as flr
from tfjxc x,tfjrc r,vallfjpjzl f,tygzl y,tfxlx l
where r.fid=x.ffjrc and f.fpjzlid=x.fpjzl and y.fid=x.fperson and l.fid=x.ffxlx
		and x.fdate>=@ffdate and x.fdate<=@fedate
order by f.fna,f.ffjlx,f.fsyjx,x.fgt,l.fid,y.fid,x.fdate