Hibernate:
/* select
p
from
Person p
where
p.streetAddress.address = ?1 */ select
person0_.id as id1_0_,
person0_.firstname as firstnam2_0_,
person0_.lastname as lastname3_0_
from
person person0_ cross
join
street_address streetaddr1_
where
person0_.id=streetaddr1_.person_id
and streetaddr1_.address=?