从条件为true的多个表中选择

Question

尝试运行一些SQL而没有运气，尝试从两个条件为true的表中选择数据。

这些表是驱动程序的详细信息和位置。这两个表都有列user_id，我想根据between部分中匹配的user_id从这两个表中获取数据。（select语句工作并返回ID）；

SELECT driver_details.firstName,
                    locations.lat,
                    locations.lng
                    FROM driver_details
                    INNER JOIN locations
                    WHERE user_id = 
                    (SELECT user_id FROM locations WHERE 
                    (lat BETWEEN 0 AND 5) AND 
                    (lng BETWEEN 0 AND 5))

我得到的错误：致命错误：调用一个成员函数bind_param（）在一个非对象在C：\xampp\htdocs\矢量\www\脚本\getDriversInRange.php行33

Answer 1

SELECT d.firstName,
    l.lat,
    l.lng
FROM driver_details d
    INNER JOIN locations l ON d.user_id = l.user_id
WHERE l.lat BETWEEN 0 AND 5
    AND l.lng BETWEEN 0 AND 5

这基本上是BWS发布内容的一个更完整的示例。

Answer 2

您需要使用两个表中常见的东西来连接正在连接的两个表...您提到了user_id

...
FROM driver_details
INNER JOIN locations
ON driver_details.user_id = locations.user_id
WHERE ...