1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| "Debut SQL
SELECT THREAD_HEADER.Title_THREAD,
EVENT.ID_EVENT,
CONTACT.Name_CONTACT, CONTACT.Alias_CONTACT, CONTACT.Email_CONTACT, CONTACT.Mobile
FROM UNIT as 'uni',
Correspond as 'corr',
THREAD_HEADER as 'thre',
appartient as 'appa',
EVENT as 'even',
participe as 'part',
CONTACT as 'cont'
WHERE thre.Title_THREAD = 'thread 1' and
uni.ID_UNIT = corr.ID_UNIT and
corr.ID_THREAD = thre.ID_THREAD and
thre.ID_THREAD = appa.ID_THREAD and
appa.ID_EVENT = even.ID_EVENT and
even.ID_EVENT = part.ID_EVENT and
part.ID_CONTACT = cont.ID_CONTACT
ORDER BY 1 ASC
INTO : t_name_contact ;
Fin SQL" |
Partager