mysql - 将 SQL Google 搜索与自己的 SQL 查询相结合

Question

我对 SQL 查询还很陌生。

我有一个google SQL Search example

SELECT cID,
       (6371 * acos
               (
                  cos(radians(51.455643)) 
                * cos(radians(latCord)) 
                * cos(radians(longCord) - radians(7.011555)) 
                + sin(radians(51.455643)) 
                * sin(radians(latCord))
               )
        ) AS distance
FROM breitengrade
HAVING distance < 50
ORDER BY distance 
LIMIT 0, 20

和自己的 SQL 查询

SELECT breitengrade.cID
    ,breitengrade.latCord
    ,breitengrade.longCord
    ,Pages.cIsActive
FROM breitengrade
INNER JOIN Pages ON breitengrade.cID = Pages.cID
WHERE cIsActive = '1'

如何将这 2 个查询合并为一个，以便获得一个结果集？

Answer 1

SELECT breitengrade.cID,
       breitengrade.latCord,
       breitengrade.longCord,
       Pages.cIsActive
       (6371 * acos
               (
                  cos(radians(51.455643)) 
                * cos(radians(latCord)) 
                * cos(radians(longCord) - radians(7.011555)) 
                + sin(radians(51.455643)) 
                * sin(radians(latCord))
               )
        ) AS distance
FROM breitengrade
INNER JOIN Pages ON breitengrade.cID = Pages.cID
WHERE cIsActive = '1'
HAVING distance < 50
ORDER BY distance 
LIMIT 0, 20