Question

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
自己写了这样一段，查询出来好多重复的，请问怎么写能去掉重复

Answer 1

如果是每一行内容完全重复的话，可以在select关键字和第一个字段中间加一个关键字distanct试试

追问

怎么写呢～

追答

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