eventually I need all the rows form table a that do not have an address. BUT the tables are not explicitly related (in the hbm). I just know that bid in both is the same thing. bid in B is the key of it.
so I need to do left outer join and something equals null at the end.