You need to explain in some detail how the database is structured before someone can help you with a query.