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