| List: | General Discussion | « Previous MessageNext Message » | |
| From: | (Hal | Date: | May 21 2011 12:47am |
| Subject: | Re: Complex Query | ||
| View as plain text | |||
>>>> 2011/05/21 00:22 +0200, Johan De Meersman >>>>
Heh. The parser is pointing out a simple syntax oversight, yes. The correct syntax for
that is select ... from (subselect) aliasname;
<<<<<<<<
And that is required whether the alias is used or not. I at those times have been tripped
up by this requirement when I had no use for the alias.
| Thread | ||
|---|---|---|
| • Complex Query | Mimi Cafe | 19 May |
| • Re: Complex Query | Claudio Nanni | 19 May |
| • Re: Complex Query | hsv | 19 May |
| • RE: Complex Query | Mimi Cafe | 19 May |
| • Re: Complex Query | Guido Schlenke | 19 May |
| • Re: Complex Query | Guido Schlenke | 19 May |
| • RE: Complex Query | Mimi Cafe | 20 May |
| • RE: Complex Query | Anupam Karmarkar | 20 May |
| • RE: Complex Query | Mimi Cafe | 20 May |
| • RE: Complex Query | Mimi Cafe | 20 May |
| • Re: Complex Query | Guido Schlenke | 20 May |
| • Re: Complex Query | Johan De Meersman | 20 May |
| • RE: Complex Query | Mimi Cafe | 20 May |
| • RE: Complex Query | Mimi Cafe | 20 May |
| • Re: Complex Query | Johan De Meersman | 21 May |
| • Re: Complex Query | hsv | 21 May |
| • RE: Complex Query | Mimi Cafe | 21 May |
