Table A (ManyToOne with Table B)
Pk
Number
Fk

Table B
Pk
IsActive

select * from TableA as a left outer join TableB as b on b.pk=a.fk where b.isActive=false and a.Number < 15

select * from TableB as b left outer join TableA as a on b.pk=a.fk where b.isActive=false and a.Number < 15

select b from TableB as b left fetch join b.tableAList as a where b.isActive=true and a.xxxxx = something

where b.isActive=false and a.Number < 15