List:General Discussion« Previous MessageNext Message »
From:Mimi Cafe Date:May 21 2011 1:13pm
Subject:RE: Complex Query
View as plain text  
Bizarre! That worked, but it appears the alias is not used.

Thanks

Mimi

=> -----Original Message-----
=> From: Hal�sz S�ndor [mailto:hsv@stripped]
=> Sent: 21 May 2011 01:48
=> To: Johan De Meersman
=> Cc: Mimi Cafe; mysql@stripped; Johan De Meersman; Guido
=> Schlenke
=> Subject: Re: Complex Query
=> 
=> >>>> 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