Error: 1248 - SQLSTATE: 42000 ER_DERIVED_MUST_HAVE_ALIAS

Description:
Message: Every derived table must have its own alias

MySql-Server , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

  1. admin
    May 7th, 2009 at 00:44 | #1

    Add an alias for each derived table and make sure that you add the alias just after the FROM clause, outside the parentheses () and make sure to use JOIN condition as necessary.

  1. No trackbacks yet.