Suppose that i have two entities - customer, book.
That dosnt have "physical relation" (they dont have FK to PK).

Both entities can can be joined based on two columns.

For example:
select * from book, customer where customer.author = book.author and customer.publisher = book.publisher

I dont want load the rellevant book by query and set them on customer. I dont to this by mapping.

To map a collection of books on Customer entities and the books will be loaded by join the given two columns.

I need this only for view.

I know that it can be achive by using in entityresultset but this is ugly. Are you know another way to map a "logical join"?

Thank you