SELECT distinct cc.pe_usename FROM Co_Candidate cc left join pe_bdfase pb on cc.pe_usename=pb.pe_usename left join Co_redsume cr on cc.pe_usename=cr.pe_usename left join Co_Inddfite ci on ci.invite_id=cr.invite_id where cc.co_usename='weihan' order by cr.add_date desc
加了distinct,只能去掉所有字段都重复的记录
你加了distinct,只是针对,所有的字段,并不能达到你要求呀!
SELECT distinct cc.pe_usename,cc.co_usename,pb.username,pb.sex,cr.add_date,ci.jgob_name FROM (select distinct pe_usename Co_Candidate where co_usename='weihan') cc left join pe_bdfase pb on cc.pe_usename=pb.pe_usename left join Co_redsume cr on cc.pe_usename=cr.pe_usename left join Co_Inddfite ci on ci.invite_id=cr.invite_id order by cr.add_date desc
FROM Co_Candidate cc
left join pe_bdfase pb on cc.pe_usename=pb.pe_usename
left join Co_redsume cr on cc.pe_usename=cr.pe_usename
left join Co_Inddfite ci on ci.invite_id=cr.invite_id
where cc.co_usename='weihan' order by cr.add_date desc
FROM (select distinct pe_usename Co_Candidate where co_usename='weihan') cc
left join pe_bdfase pb on cc.pe_usename=pb.pe_usename
left join Co_redsume cr on cc.pe_usename=cr.pe_usename
left join Co_Inddfite ci on ci.invite_id=cr.invite_id
order by cr.add_date desc