MySQL: Return a row if all joint table row have the value true

I've two tables as following.

Table A  Column Id | Column Name  1         | Test 1  2         | Test 2  

The relationship is

Table B  Column Id | Column Delivered | Column TableA_Id  1         | true             | 1  2         | true             | 1  3         | true             | 1  4         | true             | 1  5         | false            | 2  6         | true             | 2  7         | true             | 2  

What I want is to return for example for table A the record with id 1 which has a relationship with table B where all the values on table B column Delivered as true.

https://stackoverflow.com/questions/65802489/mysql-return-a-row-if-all-joint-table-row-have-the-value-true January 20, 2021 at 11:01AM