I have a problem with mapping a legacy database with JPA 1.0. The database is stored denormalized for data-mining purposes. I condensed it to a simple example that hopefully clarifies the issue. Assume I have the following two tables:I have a problem with mapping a legacy database