List:General Discussion« Previous MessageNext Message »
From:<ric Date:December 22 2002 6:06am
Subject:4.1 questions: subqueries which use dual
View as plain text  
Mysql,
    Selecting from `dual` with a simple query works fine,

mysql> select 1 x from dual;
+---+
| x |
+---+
| 1 |
+---+

but within a derived table,

mysql> select * from (select 1 x from dual) s;
ERROR 1146: Table 'test.dual' doesn't exist

Is this an oversight or is it purposefully so?

Thank you,
    Richard.


Thread
Return every Nth row in a result setSpamSucks8622 Dec
  • RE: Return every Nth row in a result setJamesD22 Dec
  • 4.1 questions: subqueries which use dualric22 Dec
    • re: 4.1 questions: subqueries which use dualVictoria Reznichenko24 Dec
  • Re: Return every Nth row in a result setric22 Dec
    • RE: Return every Nth row in a result setSpamSucks8622 Dec
      • Re: Return every Nth row in a result setBenjamin Pflugmann22 Dec
        • RE: Return every Nth row in a result setSpamSucks8622 Dec
          • Re: Return every Nth row in a result setRichard Clarke22 Dec
          • Re: Return every Nth row in a result setric22 Dec
  • Re: 4.1 questions: subqueries which use dualRichard Clarke24 Dec
    • Re: 4.1 questions: subqueries which use dualDan Nelson24 Dec
  • Re: 4.1 questions: subqueries which use dualRichard Clarke24 Dec
    • Re: 4.1 questions: subqueries which use dualMark Matthews24 Dec