Can I perform multiple row join?

[Randell D.]

Folks,
I have two tables - one called parent, the other called group.

table group is made up of ID,parentID,groupHash and groupName.

table parent is made up of ID,title,group1Hash,group2Hash,group3Hash (and
other columns)

Each of the group hashes in table parent correspond to a group hash in table
group (ie parent.group1Hash exists in/as group.groupHash and
parent.group2Hash also exists (on another row) in/as group.groupHash).

This means table parent can have up to three groupHash's noted in a single
row and each of these groupHash's will have its name in a corresponding row
in table group (using groupHash as key).

Can I perform a select whereby I read a row from parent and use its
group1Hash, group2Hash and group3Hash to retrieve their corresponding names
from table group (all in one select statement)? Or must I perform three or
four individual selects to get the desired values from the two tables.

All help, via the newsgroup is much appreciated,

Thanx
randelld