=======SQL语句请教各路朋友,大家请进==========

[zhlym]

我如下这句要改成只取pubtable库的sellautoid字段唯一值，应怎改？
select a.autoid,a.monberin,a.carno,a.carno1,a.bx_date,a.bx_time,a.yj_date,a.yj_time,a.wx_suxi,b.indate,b.antrueman,b.enddate from reparein a, pubtable b where a.officeid='"&Session("officeid")&"' and b.officeid='"&Session("officeid")&"' and a.monberin=b.sellautoid and a.monthjie='0' and b.indate between '"&sdate1&"' and '"&sdate2&"' and b.antrue=2 order by a.monberin desc

请大家看清楚我的要求,不要select distinct sellautoid from pubtable出现这种情况

[zhangxian_gege]

select a.autoid,a.monberin,a.carno,a.carno1,a.bx_date,a.bx_time,a.yj_date,a.yj_time,a.wx_suxi,b.indate,b.antrueman,b.enddate from

reparein a left outer join pubtable b on a.officeid='"&Session("officeid")&"' and b.officeid='"&Session("officeid")&"'

and a.monberin=b.sellautoid and a.monthjie='0' and b.indate between '"&sdate1&"' and '"&sdate2&"' and

b.antrue=2 order by a.monberin desc
或者以下语句

select a.autoid,a.monberin,a.carno,a.carno1,a.bx_date,a.bx_time,a.yj_date,a.yj_time,a.wx_suxi,b.indate,b.antrueman,b.enddate from

pubtable a left outer join reparein b on a.officeid='"&Session("officeid")&"' and b.officeid='"&Session("officeid")&"'

and b.monberin=a.sellautoid and a.monthjie='0' and b.indate between '"&sdate1&"' and '"&sdate2&"' and

b.antrue=2 order by a.monberin desc

因为我没有具体的表结构,所以只能这样写了

[chjpeng]

建议你搜一下group by的用法

[zhlym]

TO zhangxian_gege(张仙)

你的方法一样不行咧

[zhlym]

还是我自己想到办法了,汗,谁顶有分现在

[jarraytan]

啥意思啊,楼主,没看明白.

[tianch]

select sellautoid from pubtable group by sellautoid

[hbhbhbhbhb1021]

连接的时候选择左连接或右连接，不要全连接就可以了

[zhlym]

TO 各位

第一: 不要为了得分乱写呀

第二: 我想要例子, 还望大家回贴时贴出例子