MySQL Multiple Select Query

Question

I want to create mysql request to the server I want to retrieve users from the table that as I do not have in friends list.

Here's how I'm trying to learn but I do not receive please help me

SELECT
  t1.*, t2.*
FROM
  users as t1,
  friends as t2
WHERE
  t2.user_id='1'
  and t2.fr_id!=t1.id
ORDER BY RAND()

Answer 1

The query you want is something like:

SELECT t1.*, t2.*
FROM users t1 left outer join
     friends t2
     on t2.fr_id = t1.id and
        t2.user_id = '1'
WHERE t2.user_id is null
ORDER BY RAND();

I'm not sure what the t2.user_id = 1 is doing. It is not needed if you are looking through the entire friends list.