SQL赋值问题

select t1.fitemid,t2.fnumber,t2.fname,t2.fmodel,sum(t1.fqty),t2.fstoreunitid,t3.fname
from icinventory t1,t_icitem t2,t_measureunit t3
where t1.fitemid=t2.fitemid and t2.fnumber like '03.%' and t3.fmeasureunitid=t2.funitid
group by t1.fitemid,t2.fnumber,t2.fname,t2.fmodel,t2.fstoreunitid,t3.fname
这个语句我在前台测试时两列fname都是t3.fname的值，但在SQL的查询分析器里就没任何问题。这怎么解决呢？