1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
| BEGIN
SELECT
RESOURCES.RESOURCES_NAME AS Resources,
RESOURCE_SERVICES.SERVICES_NAME AS ServiceName,
RESOURCE_SERVICES.LAST_NAME_RESPONSIBLE_SERVICES AS LastNameResponsible,
RESOURCE_SERVICES.FIRST_NAME_RESPONSIBLE_SERVICES AS FirstNameResponsible,
RESOURCE_SERVICES.STREET_SERVICES AS StreetServices,
RESOURCE_SERVICES.STREET_NUMBER_SERVICES AS NumberStreetServices,
RESOURCE_SERVICES.BOX_NUMBER_SERVICES AS BoxNumberStreetServices,
POSTCODE.POST_NUMBER AS PostCodeNumber,
POSTCODE.CITY AS PostCodeCity,
VALID_LINE_RF.QUANTITY AS Quantity,
`EVENT`.START_DATE_TIME AS EventDate,
`EVENT`.EVENT_NAME AS EventName,
RESOURCE_SERVICES.ID_RES_SERV
FROM
VALID_LINE_RF
Inner Join RESOURCES ON VALID_LINE_RF.ID_RESSOURCES = RESOURCES.ID_RESSOURCES
Inner Join RESOURCE_SERVICES ON VALID_LINE_RF.ID_RES_SERV = RESOURCE_SERVICES.ID_RES_SERV
Inner Join POSTCODE ON POSTCODE.ID_POSTCODE = RESOURCE_SERVICES.ID_POSTCODE
Inner Join CREATE_AN_ENTRY ON CREATE_AN_ENTRY.ID_FORM = VALID_LINE_RF.ID_FORM
Inner Join `EVENT` ON CREATE_AN_ENTRY.ID_EVENT = `EVENT`.ID_EVENT
WHERE
VALID_LINE_RF.ID_FORM = idForm;
END |
