fields.java

select(
    DIRECTOR.NAME.as(PERSON.NAME),
    DIRECTOR.ADDRESS.as(PERSON.ADDRESS)
)
.from(DIRECTOR)
.union(
    select(
        ACTOR.NAME.as(PERSON.NAME),
        castNull(PERSON.ADDRESS).as(PERSON.ADDRESS)
    )
  .from(ACTOR)
)
.fetchInto(PERSON)