***BOGO*** Trouble with alias

[mdimartino@xxxxxxxxxxxxxxxxx]

I having some issues setting aliases om my query. The details are as follows

Table-Name = xcircuits
   xcircuitsID (pimary key)
   circuit
   popA (secondary key refers to pirmary key on xpops table)
   popZ (secondary key refers to pirmary key on xpops table)

Table-Name = xpops
   xpopID
   pops


Query
   SELECT l1.POPS AS`popA` , l2.POPS AS `popZ`
   FROM  xcircuits
   INNER JOIN xpops.POPS AS l1
   ON xcircuits.popA = l1.popID
   INNER JOIN xpops.POPS AS l2
   ON xcircuits.popA = l2.popID
   LIMIT 0 , 30

Error: Table xpops.pops doesn't exits


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