连接3个表并使用WHERE


Joining 3 tables and using WHERE

我有三个表:-

用户(用户名、业务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"。