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

[M44ti]

[PHP] 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 
       ) AS sb ORDER BY sb.shout_datastamp ASC
[PHP] pobierz, plaintext 

Unknown column 'sb.shout_datastamp' in 'order clause'

tutaj tez ale dla mnie nie jest jasny co zle robie :/

ok naprawione

kod działa w tej postaci

[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_id DESC LIMIT 0,8 
       ) AS sb 
	   ORDER BY sb.shout_id ASC
[SQL] pobierz, plaintext 

nie wiem czemu ale ts.shout_datestamp nie widziało w 1 zapytaniu

Ten post edytował M44ti 7.04.2012, 16:35:28