Query vereinfachen

[Forumsgast]

Kann man diesen SQL Befehl irgendwie kürzen:

SELECT slm.seasons_ID, s.seasons_ID, slm.meetings_ID, m.meetings_ID, slm.locations_ID, l.locations_ID, s.season_name, l.location_name, m.meeting_name, m.meeting_date, m.meeting_added_date, m.meeting_type FROM sum_slm AS slm LEFT OUTER JOIN seasons AS s ON slm.seasons_ID = s.seasons_ID LEFT OUTER JOIN meetings AS m ON slm.meetings_ID = m.meetings_ID LEFT OUTER JOIN locations AS l ON slm.locations_ID = l.locations_ID ORDER BY m.meeting_date DESC

Ich habe versucht * zu benutzen, aber irgendwie hat es nicht funktioniert.

Ich würde die Abfrage erstmal noch verlängern, indem da mehr Formatierung reinkommt.
Dann hast Du auch in zwei Monaten noch eine Chance zu verstehen, was da gemacht wird.

SELECT
		l.locations_ID,  l.location_name,
		m.meetings_ID, m.meeting_name, m.meeting_date, m.meeting_added_date, m.meeting_type,
		s.season_name, s.seasons_ID,
		slm.seasons_ID, slm.meetings_ID, slm.locations_ID
FROM
		sum_slm AS slm
LEFT OUTER JOIN
		seasons AS s
ON
		slm.seasons_ID = s.seasons_ID
LEFT OUTER JOIN
		meetings AS m
ON
		slm.meetings_ID = m.meetings_ID
LEFT OUTER JOIN
		locations AS l
ON
		slm.locations_ID = l.locations_ID
ORDER BY
		m.meeting_date DESC