php - 多个表和查询

Question

我如何将这样的东西连接在一起:

$query = ("SELECT * FROM profiles,follow
           WHERE follow.friend ='$user' 
               AND follow.user !='$user' 
               AND profiles.user1 =follow.user 
           ORDER BY id DESC limit 20");

或

("SELECT * FROM profiles WHERE user1='$user'");

我需要查询来显示两个不同的东西，我该怎么做。

Answer 1

这个？

SELECT
    *
FROM
    follows
INNER JOIN
    profiles
    ON (profiles.user1 = follow.user)
WHERE
    follow.friend = '{$user}'
    AND follow.user != '{$user}'
    AND profiles.user1 = '{$user}'
ORDER BY
    profiles.id DESC
LIMIT 20