How to select records from two tables?

Question

MySQL

Hello.
There is a users table. It has fields id, login, email, etc.
There is one more dialogs table. It contains the fields id, receiver, sender, etc.
I need to select all records from the users table, but on the condition that the dialogs table has a reciver != users.id field and a dialogs.sender != users.id field.
I hope I explained clearly ...
How to do this?

Answer 1

Select *
From users u, dialogs d
Where u.id!=d.sender and u.id!=d.receiver