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 QueryMimi Cafe19 May
  • Re: Complex QueryClaudio Nanni19 May
  • Re: Complex Queryhsv19 May
RE: Complex QueryMimi Cafe19 May
  • Re: Complex QueryGuido Schlenke19 May
  • Re: Complex QueryGuido Schlenke19 May
    • RE: Complex QueryMimi Cafe20 May
      • RE: Complex QueryAnupam Karmarkar20 May
        • RE: Complex QueryMimi Cafe20 May
          • RE: Complex QueryMimi Cafe20 May
            • Re: Complex QueryGuido Schlenke20 May
              • Re: Complex QueryJohan De Meersman20 May
                • RE: Complex QueryMimi Cafe20 May
                  • RE: Complex QueryMimi Cafe20 May
                  • Re: Complex QueryJohan De Meersman21 May
                    • Re: Complex Queryhsv21 May
                      • RE: Complex QueryMimi Cafe21 May