Hello,



fb 2.1 cs is running



Now I have four tables:



Persons:

ID

Name

EMAIL



ORDER:

ProjectID

PERSON_WHO_GET (references ID from Persons)

STATUS



Projects:

ProjectID

Manager (references ID from Persons)



ProjectSEND:

ProjectID

PERSON_WHO_GET_INFO (references ID from Persons)



Each Person (ID) is unique, each ProjectID too. Every order has one
person_who_get, one Project has 1:n orders. In ProjectSend can I configure
many persons who get an email for one Project.



Starting with the order table and its status (open), I can reference to the
project, than to the projectSend-Table. I would get all Persons (ID)
grouped, which are deposited with the order, the project (in dependence on
procect) and who is configurated to became an email (ProjectSend)



For example:



Order 123

Person who get Order: 2

For Projekct ABC



ProjectManager for ABC: 23



ProjectSend f

Project: ABC, Person_who_get_info: 32

Project: ABC, Person_who_get_info: 33



Now I would get some results:

Person 2

Person 23

Person 32

Person 33



It is possible without a stored procedure?



Thanks in advance.



Best regards



Olaf







[Non-text portions of this message have been removed]