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,gro upHash and groupName.

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

Each of the group hashes in table parent correspond to a group hash in table
group (ie parent.group1Ha sh exists in/as group.groupHash and
parent.group2Ha sh 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