I have three tables (below). I'm having a problem conceptualizing how to map the METRICS table such that I can do the included query...it doesn't seem as though it should be it's own class, so I would think that there would be a way to reference it in another manner w/in a mapping for the cust_totals or totals_desc. New to this, so open to references to other forum posts, outside docs, etc. (yes, picked up Hibernate in Action as well). I did a search and didn't see anything that seemed to be applicable. (Want to do this as "correct" as possible, so I don't want any naivete to cause me to miss something, hence, the reluctant post)

TIA


that I wish to do the following query on:



Customer_totals can have cst_codes like ABC, XYZ, MNO, JKL. Metrics is a subset, say, just XYZ and MNO. Totals_desc has the i18n descriptions of all the codes, even those not in customer_totals.

And, if it helps, using an established DB design and MS SQL