New to sqlite and database work, how do I do this query?

New to sqlite and database work, how do I do this query?

I have a project I am working on and I am wanting to create a query that
involves two tables from my database as pictured below.

What I want from the query is if DMN_LIST_COLS on the DOMAIN data table
equals 1 I want to retrieve all the values from DMV_VALUE_1 of the
DOMAIN_VALUE data table. What is the correct format for this query?
I know the query below is incorrect but how do I change this?
SELECT DMV_VALUE_1 FROM DOMAIN_VALUE WHERE DMN_LIST_COLS='1' FROM DOMAIN