Assuming that UserID field is PK in the parent table in FK in the chilad table

SELECT * FROM users ;
  WHERE UserID NOT IN ( SELECT UserID FROM transactions )
* or using correlated query
SELECT * FROM users us ;
  WHERE NOT EXISTS ( SELECT UserID FROM transactions tr ;
         WHERE tr.UserID = us.UserID )

>Greetings friends;
>
>I have two tables one it contains users and the other transactions for user.
>I need to develop a query whose result is the users that have not done any transaction.
>
>How do I make it.?
>
>Thanks a lot.