Zitat von APH
Beitrag anzeigen
so in der ARt
Code:
SELECT eventId, eventStart, MAX(s1.name) as union1Name,MIN(s2.name) as union2Name, s1.category FROM `event` e JOIN `sportunion` s1 ON (s1._eventId = e.eventId) JOIN `sportunion` s2 ON (s2._eventId =e.eventId ) GROUP BY eventId,eventStart,s1.category ORDER BY eventId
Kommentar