In the example of my blog, the userid and username is the same. Similarly for groupid and groupname. In that case, our table is normalized. In your case, I think you can create a table view to achieve what you want.
[Message sent by forum member 'swchan2' (swchan2)]
http://forums.java.net/jive/thread.jspa?messageID=216560