How to properly get data through linked table?

Question

SQL

There is a table users , it has fields id, vk_user_id ...
There is a table transactions, it has a connection transactions.user_id = users.id .
How to correctly get all transactions of a user, having vk_user_id in hand ?

Tried like this, but I'm clearly doing something wrong:

SELECT transactions.id 
FROM transactions 
LEFT JOIN users ON users.id = transactions.user_id
WHERE users.vk_user_id = 111111

Answer 1

Use INNER JOIN