On Fri, May 23, 2008 at 12:04 PM, <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] wultsch (aim) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]