SQL-Abfrage - kein Order By max() AS ??

[Flo T.]

Hallo Chriz!

SELECT
            *,
            max(date + time) AS datum
         FROM events
         datum < '1161424143'
         GROUP BY id_concert
         ORDER BY datum DESC

Where is your where? ;)

Unknown column 'datum' in 'where clause

Zuerst wird das where ausgewertet und dann erst 'datum'. Deswegen geht's nicht!

Probier mal:

  
         SELECT  
            *,  
            max(date + time) AS datum  
         FROM events  
         HAVING datum < '1161424143'  
         GROUP BY id_concert  
         ORDER BY datum DESC  

lg Flo