On Fri, May 23, 2008 at 1:35 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: >>> SELECT >>> p1.POPS AS `POPA`, >>> p2.POPS AS `POPZ` >>> FROM >>> circuits >>> INNER JOIN pops.POPS as p1 WHERE circuits.popID_A =p1.popID >>> INNER JOIN pops.POPS as p2 WHERE circuits.pop_ID_Z =p2.popID
Wow... I can't believe I wrote that originally. Definitely time for a 3 day break ;) -- 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]
