mysql - As shown in the figure, from these 2 table I want to select a record from 1st table if only if 'is_verified' field in 2nd table contain null or 1

Question

As shown in the figure, from these 2 table I want to select a record from 1st table if and only if is_verified() field in 2nd table contain all nulls or mixture of nulls and 1s against a particular review_id.

Answer 1

Try this but check change the column name and table as you have in database.

For specific review id:

Select * from table1 a
Inner join table2 b ON a.id = b.review_id
WHERE ( b.is_verified IS NULL OR b.is_verified = 1) AND a.id = 5049

For all reviews:

Select * from table1 a
    Inner join table2 b ON a.id = b.review_id
    WHERE ( b.is_verified IS NULL OR b.is_verified = 1);

If one of them 0 skip record:

Select * from table1 a
    Inner join table2 b ON a.id = b.review_id
    WHERE 
AND b.is_verified != 0
AND a.id = 5049

Anti JOIN EXAMPLE (will skip all others):

SELECT t1.*
FROM Table1 AS t1
WHERE NOT EXISTS
      ( SELECT *
        FROM Table2 AS t2
        WHERE t2.reviewer_id = t1.id
          AND t2.is_verified = 0
      )