如何在数据库中按照字段唯一值显示

[hubhub]

我建了一个关联表，但是我想以一个唯一的字段为标示，该字段显示不能重复，如下：
SELECT DISTINCT db_jl_zzps.jl_zs_code,
db_xmjl.jl_name,
db_xmjl.jl_sex,
db_xmjl.jl_xl,
db_xmjl.jl_birthday,
db_jl_zzps.jl_qy_name,
db_xmjl.jl_zc,
db_jl_zzps.jl_px_code,
db_jl_zzps.jl_sg_nx,
db_jl_stand_a.for_name,
db_jl_stand_a.for_area,
db_jl_stand_a.for_money,
db_jl_stand_a.for_scn,
db_jl_stand_a.for_zldj,
db_jl_stand_a.for_dwname,
db_jl_stand_a.for_e_date,
db_jl_stand_b.for_name,
db_jl_stand_b.for_area,
db_jl_stand_b.for_money,
db_jl_stand_b.for_scn,
db_jl_stand_b.for_zldj,
db_jl_stand_b.for_dwname,
db_jl_stand_b.for_e_date,
db_jl_zzps.jl_sb_dj,
db_jl_zzps.jl_old_date,
db_xmjl.jl_sfzh
FROM db_jl_stand db_jl_stand_a RIGHT OUTER JOIN db_jl_zzps ON db_jl_stand_a.for_year = db_jl_zzps.jl_sb_year,
db_xmjl,
db_jl_stand db_jl_stand_b
WHERE ( db_jl_zzps.jl_zs_code = db_xmjl.jl_zs_code ) and
( db_xmjl.jl_sfzh = db_jl_stand_a.jl_sfzh ) and
( db_xmjl.jl_sfzh = db_jl_stand_b.jl_sfzh ) and
( db_jl_zzps.jl_sb_year = db_jl_stand_b.for_year ) and
( db_jl_stand_a.for_no <> db_jl_stand_b.for_no )
ORDER BY db_jl_zzps.jl_qy_name ASC,
db_jl_zzps.jl_sb_dj ASC;
我想以第一个字段为标示（db_jl_zzps.jl_zs_code），第一个字段不能重复，使用DISTINCT还是不行，应该怎么办！