distinct 报错！！

[sjshuang]

SELECT deport_mid.id,
distinct deport_mid.commodity_code,
deport_mid.ammount,
deport_mid.state,
deport_mid.commodity_code,
deport_mid.remark,
deport_mid.opt_code,
deport_mid.deport_top_code,
commodity.unit,
commodity.packaging,
commodity.name,
deport_mid.price,
commodity.price ,
deport_mid.getdate
FROM deport_mid right join commodity on deport_mid.commodity_code = commodity.code order by deport_mid.getdate desc
为什么不能用 呢？
放在的一行也没效果

[-狙击手-]

SELECT  distinct deport_mid.id,  
        deport_mid.commodity_code,  
        deport_mid.ammount,  
        deport_mid.state,  
        deport_mid.commodity_code, 
        deport_mid.remark,  
        deport_mid.opt_code,  
        deport_mid.deport_top_code, 
        commodity.unit,  
        commodity.packaging,  
        commodity.name,  
        deport_mid.price,  
        commodity.price , 
deport_mid.getdate 
    FROM deport_mid right join commodity on deport_mid.commodity_code = commodity.code order by deport_mid.getdate desc 

[让你望见影子的墙]

distinct位置改一下
SELECT distinct deport_mid.id,  
         deport_mid.commodity_code,  
        deport_mid.ammount,  
        deport_mid.state,  
        deport_mid.commodity_code, 
        deport_mid.remark,  
        deport_mid.opt_code,  
        deport_mid.deport_top_code, 
        commodity.unit,  
        commodity.packaging,  
        commodity.name,  
        deport_mid.price,  
        commodity.price , 
deport_mid.getdate 
    FROM deport_mid right join commodity on deport_mid.commodity_code = commodity.code order by deport_mid.getdate desc 

[dawugui]

SELECT  distinct 
        deport_mid.id,  
        deport_mid.commodity_code,  
        deport_mid.ammount,  
        deport_mid.state,  
        deport_mid.commodity_code, 
        deport_mid.remark,  
        deport_mid.opt_code,  
        deport_mid.deport_top_code, 
        commodity.unit,  
        commodity.packaging,  
        commodity.name,  
        deport_mid.price,  
        commodity.price , 
        deport_mid.getdate 
FROM deport_mid right join commodity 
on deport_mid.commodity_code = commodity.code 
order by deport_mid.getdate desc 

[claro]

了解