Showing join-table info in a table

I have the following 2 tables in my database:

support group table
- int id
- string sgname

somerandomtable
- int id
- int foo
- string randomname
- int sgid (joined to support group table::id)

I have a JPAContainer which reads in the random table data, and it becomes the data source for my display table, but I want to display the sgname value, not the integer sgid. I’m thinking this should be fairly easy to do, but I have not figured out the correct way to make it happen. Can someone point me at some sample code or tell me what I need to do?

thanks,

nbc

I forgot that I had asked a similar question some time ago, and got an answer… See the thread “How to create a generated column using a foreign key object”. Sorry for the duplication…

nbc