| 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 set | SpamSucks86 | 22 Dec |
| • RE: Return every Nth row in a result set | JamesD | 22 Dec |
| • 4.1 questions: subqueries which use dual | ric | 22 Dec |
| • re: 4.1 questions: subqueries which use dual | Victoria Reznichenko | 24 Dec |
| • Re: Return every Nth row in a result set | ric | 22 Dec |
| • RE: Return every Nth row in a result set | SpamSucks86 | 22 Dec |
| • Re: Return every Nth row in a result set | Benjamin Pflugmann | 22 Dec |
| • RE: Return every Nth row in a result set | SpamSucks86 | 22 Dec |
| • Re: Return every Nth row in a result set | Richard Clarke | 22 Dec |
| • Re: Return every Nth row in a result set | ric | 22 Dec |
| • Re: 4.1 questions: subqueries which use dual | Richard Clarke | 24 Dec |
| • Re: 4.1 questions: subqueries which use dual | Dan Nelson | 24 Dec |
| • Re: 4.1 questions: subqueries which use dual | Richard Clarke | 24 Dec |
| • Re: 4.1 questions: subqueries which use dual | Mark Matthews | 24 Dec |
