SQL语句问题，大神请进

select vwicbill_8.ffullnumber,vwicbill_8.fitemname,vwicbill_8.fitemmodel,icinventory.fbatchno,vwicbill_8.fauxpropidname,vwicbill_8.fdcstockidnumber,vwicbill_8.fdcstockidname,icinventory.fqty,vwicbill_8.fsupplyidname,vwicbill_8.forderbillno,vwicbill_8.fsourcebillno from icinventory
left join vwicbill_2 on icinventory.fbatchno=vwicbill_2.fbatchno
left join vwicbill_8 on vwicbill_2.fbatchno=vwicbill_8.fbatchno
Order BY vwicbill_8.fdcstockidname
自己写了这样一段，查询出来好多重复的，请问怎么写能去掉重复

怎么写呢～

select distanct vwicbill_8.ffullnumber ...后面照旧