多表联合查询4个表都有相同一个字段名，需要显示4个表的全部信息？

[fulirongWY]

需要把下面4个表查询出来以“CACC”为查询字段，要求每个表的字段信息全部显示出来！！

表WaterMeterInfo
字段名： CACC MeterNo Seq LabelNo PhysicsNo Password Type BalMode WMLoc WMSNum WMBNum Model LastPurChaseTime PurchaseTimes WProTypeCode HisArrear AIndicator ReimbursementStatus VirtualPhysicsNo VirtualLabelNo GetNoFrom Is CreateRealNo caliber unit CreateDate ModBy ModDate

表ClientBInfo
字段名：CACC Name ID Address Phone OpenBuCode OpenOpCode OpenDate LogOpCode LogDate LgOutBuCode CreateBy CreateDate ModBy ModDate AIndicator


表ClientWInfo
字段名：CACC PNum AIndicator OpenBuCode OpenOpCode OpenDate LgOutOpCode LgOutDate LgOutBuCode CreateBy CreateDate ModBy ModDate Remark surplus


表SellsInfo
字段名： CACC Seq Sdate CbuinCode MeterNo LabelNo MeterType MeterModel Samt Sstere SopertCode SbusinCode Ptype

[wzwcn]

select a.*,b.*,c.*,d.* from WaterMeterInfo a inner join ClientBInfo b on
a.CACC=b.CACC inner join ClientWInfo c on b.CACC=c.CACC inner join SellsInfo d
on c.CACC=d.CACC where xxxxxxx

上面是用内连接的，不知道是否复合你的情况，不合自己改别的连接