50分求助..................
有两个表tab1(user_no ,name,write)其中:user_no为主键
user_no name write
1 b 2
tab2 user_no man man_sn
1 f 1
1 f 2
用: select distinct
a.user_no,a.name,a.write from tab1 a , tab2 b
where a.user_no=b.user_no
order by a.write,b.man_sn
查询的时候.显示的是两条记录.我想只显示一条......该怎么写呢??