There are no common columns between those 2 tables, so there is no way to directly join them; and that would throw an error upon execution.
If you were using an SQL IDE (eg SSMS), then intellisense would have pointed those out to you in the query text.
You also have a Sales table in there; and that does have references for both the Customer and the Painting. You could use this as a
bridge table to make the connection from your Customers to your paintings.
FROM Customer c
INNER JOIN Sales s ON c.Customer_ID = s. Customer_ID
INNER JOIN Painting p ON s.Paint_ID = p.Paint_ID
Going back to using an IDE dedicated for SQL to design your queries... You will notice that your SELECT list has
Name highlighted. This is because it is a "Special" or "Reserved" word.
I generally will rename columns so that I don't have to deal with it, but if you do keep that column name it should be escaped when you use it within a query.
SELECT [name]