***BOGO*** Re: Query Output Issue

["Rob Wultsch" <wultsch@xxxxxxxxx>]

On Fri, May 23, 2008 at 12:04 PM,  <mdimartino@xxxxxxxxxxxxxxxxx> wrote:
> Thanks for the quick reply, however i am getting a failure on line 2.
>
> SELECT
> 11.POPS AS `POPA`,
> 12.POPS AS `POPZ`
> FROM
> circuits
> INNER JOIN pops.POPS as 11 WHERE circuits.popA = 11.popID
> INNER JOIN pops.POPS as 12 WHERE circuits.popZ = 12.popID
>
> Table-name = circuits
> circuitID
> popA   (secondary key referencing pops.popID)
> popZ   (secondary key referencing pops.popID)
>
>
> table-name = pops
> popID
> pops

Don't alias as a number, or if you do quote escape it...

Note I used l1 and l2 for table aliases, not 11 and 12.

-- 
Rob Wultsch
wultsch@xxxxxxxxx
wultsch (aim)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx