我有三个表:-
用户(用户名、业务id等)
业务(business_id、service_type、纬度、经度等)
地址(address_id、country_iso等)
我有以下查询,它运行良好:
SELECT username, users.business_id, businesses.latitude, businesses.longitude
FROM users
JOIN businesses
ON users.business_id = businesses.business_id
WHERE service_type = ?
现在,我还想通过"country_iso"值("addresses"表中的一列)来过滤结果。
我试着做以下事情,但我得到了一个错误:
SELECT username, users.business_id, businesses.latitude, businesses.longitude
FROM users
JOIN businesses
ON users.business_id = businesses.business_id
JOIN addresses
ON businesses.address_id = addresses.address_id
WHERE businesses.service_type = ?
AND addresses.country_iso = ?
我也尝试了以下操作,但仍然出现错误:
SELECT username, users.business_id, businesses.latitude, businesses.longitude
FROM users
JOIN businesses
ON users.business_id = businesses.business_id
AND businesses.service_type = ?
JOIN addresses
ON businesses.address_id = addresses.address_id
WHERE addresses.country_iso = ?
获得我需要的结果的正确方法是什么?
感谢Juergen d的评论,我意识到我没有正确打印错误消息。我收到错误消息:错误:1054子句""中的未知列"businesss.address_id"
因此,现在我注意到"address_id"列实际上在"business"表中被称为"address"。