Hello,
I have two tables both are entity (both have a primary key).
cat and format

I would like to query cat and bring back all format_name where the format_id(s) are equal. This simple query
mysql> select cat.cat_name, cat.cat_id, format.format_name
-> from cat, format
-> where cat.format_id = format.format_id;

Currently I have two separate mappings. I need to create a mapping for this. I do not believe it is a one-to-many or anything where a set is involved, and could use some help in distinguishing my need.

Thanks,
Scott



mysql> describe cat;
+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| cat_id | int(8) | NO | PRI | 0 | |
| cat_name | varchar(50) | YES | | NULL | |
| format_id | int(8) | YES | MUL | 1 | |
+-----------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> describe cat;
+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| cat_id | int(8) | NO | PRI | 0 | |
| cat_name | varchar(50) | YES | | NULL | |
| format_id | int(8) | YES | MUL | 1 | |
+-----------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

Set up a relationship. That's exactly what you need. Query a cat, get back all the matching format_ids in a collection in the Cat class. Hibernate will do all the work if you just call a simple load

After much investigating, the final answer to my problem was to create a One-to-one association pp220 in the action book.

Thanks for all the replies, this list really delivers results.