select * from cmbuyinfo,newupdate Where cmbuyinfo.account='vvvvvv'and newupdate.account='vvvvvv'
产生了如图的数据，但ID为36的表只有一个确显示3条！！！！怎么解决阿！！！

select distinct(id), * from cmbuyinfo,newupdate Where cmbuyinfo.account='vvvvvv'and newupdate.account='vvvvvv'

不行

服务器: 消息 209，级别 16，状态 1，行 1
列名 'id' 不明确。

你把*号写成相应的字段撒

还是不行，改成相应的字段就又会多一条  列名 '字段' 不明确。。。。！！！

select * from cmbuyinfo a ,newupdate b Where a.account=b.account and a.account='vvvvvv'

select * from cmbuyinfo a ,newupdate b Where a.account*=b.account and a.account='vvvvvv'

select distinct id  * from cmbuyinfo,newupdate Where cmbuyinfo.account='vvvvvv'and newupdate.account='vvvvvv'

group by