zapytanie i podzapytanie (..(ORDER BY DESC)ORDER BY ASC ), Every derived table must have its own alias Opcje

[M44ti]

Witam co tu robię źlę ?

[SQL] pobierz, plaintext 
SELECT * FROM( 
     SELECT ts.shout_id, ts.shout_name, ts.shout_message, ts.shout_datestamp, ts.shout_ip, ts.shout_hidden, tu.user_id, tu.user_name, tu.user_avatar, tu.user_level, tu.user_lastvisit, tu.user_status 
      FROM evo_shoutbox AS ts 
      LEFT JOIN evo_users AS tu ON ts.shout_name=tu.user_id 
      WHERE shout_hidden='0' 
      ORDER BY ts.shout_datestamp DESC LIMIT 0,8 
  ) ORDER BY shout_datastamp ASC
[SQL] pobierz, plaintext 

Every derived table must have its own alias

Ten post edytował M44ti 7.04.2012, 14:25:30