SQL中的列不是一对多关系中的一对一值

I am trying to write a mysql query to select all rows of a table where the one to one relation column is 0 of a one to many relation. basicaly i want all leads where finished is not 1.I am trying to write a mysql query to select al