SQL JOIN query, how right?

Question

MySQL

Hello everyone, there are 2 tables:
users:
id | name | surname
courses:
id | user_id | description | type
How will it be correct to get all courses with type = 1 + by user_id to get name and surname?
I have been working with SQL JOIN's for a long time, I don’t even know how to do it ..
something like this?:

SELECT c.*, u.name, u.surname FROM courses AS c INNER JOIN users AS u ON c.type = 1 AND u.id = c.user_id

??

Answer 1

SELECT c.*, u.name, u.surname FROM courses c 
LEFT JOIN users u ON u.id = c.user_id WHERE c.type = 1