SELECT ShowType, ShowTypeColor
FROM ShowType
WHERE Repertoire_No=#attributes.Repertoire_No#
ORDER BY ShowType
SELECT S.ShowID,
S.titre,
S.extrait,
S.ShowDate,
S.date_fin,
S.heure_debut,
S.heure_fin,
ST.ShowType, ST.ShowTypeColor
FROM Show S, ShowType ST
WHERE S.ShowTypeID=ST.ShowTypeID
AND S.actif='3'
AND S.Repertoire_No=#attributes.Repertoire_No#
ORDER BY S.ShowID, S.ShowDate, S.heure_debut