麻烦大家进来帮帮忙！谢谢

[pengweimi0614]

select c.*, u.UserName as UserName,City.CityName as CityName,
country.countryName ,address.city
from Customer c inner join
address on c.customerCode = address.customerCode left join
Users u on u.UserId = c.UserId left join
City on City.CityId = c.CityId left join
country on c.countryCode = country.countryCode

去重问题　
　　　　一个地址表　客户表　城市表　国籍表　用户表做的联合查询
查询出一个客户有三条数据，姓名重复了　客户他有三个联系地址　分为三条　地址我是做的一个连接　另外显示　地址信息显示是没错误的

[hongcha99]

估计是你的语句写错了浩浩检查检察