SQL insert a column from another table, how to write a condition?

Question

MySQL

Hello.
I have 2 tables
One is called images

Another products

The task is to transfer the url column (links to the image) from the images table to the products table in the (images) field in the picture it is not visible.
But you need to transfer with the condition that images.object_id be equal to products.id and images.object = "product"
I try to do this:

SELECT url, object_id FROM images INNER JOIN products ON images.object_id = products.id AND images.object = "product"

I don't know much about SQL queries, but something like this.
Can you at least just advise what to use here? Or read an article on how to use JOIN with conditions

Answer 1

SELECT  url, object_id 
FROM images 
INNER JOIN products ON images.object_id = products.id 
WHERE images.object = "product"

in JOIN only fields on which we unite. Conditions - in WHERE