one to many to many to many query problem

[gamisens]

I have a database with the following structure: an items table has a one to many relationship to a groups table. The groups table has a many to many relationship to a members table through a connecting table of group members. I need to find an item by searching for member data but there is no direct relation between the items table and the members table (only through the groups). How can I construct an SQL query to accomplish this?

 

[Nancy2]

Include the groups table in your query to link the members to the item.