论坛 › MySQL应用开发 › 求大神指出语句的错误

mary_cuiying 发表于 2015-7-24 14:06:17

求大神指出语句的错误

select i.name
from customer i,property_customer h,property b
where
i.id in (select h.customer_id
from property_customer h,property b
where h.property_id=b.id);

查询的结果是：每个客户名称都出现好多次{:soso_e101:}

pztx1992 发表于 2016-9-8 14:13:37

distinct i.name

查看完整版本: 求大神指出语句的错误