Re: Query Output Issue

[mdimartino]

----- Original Message -----
From: "Rob Wultsch" <wultsch@stripped>
To: mdimartino@stripped
Cc: "MYSQL General List" <mysql@stripped>
Sent: Friday, May 23, 2008 1:42:07 PM GMT -08:00 US/Canada Pacific
Subject: Re: Query Output Issue

On Fri, May 23, 2008 at 1:35 PM, Rob Wultsch <wultsch@stripped> 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
wultsch@stripped
wultsch (aim)


----- Original Message ---

Still fails with the same error on line 7
This time included  the actual table information.

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

-- Table "xcircuits" DDL

CREATE TABLE `circuits` (
  `customerID` int(11) default NULL,
  `end_customer` varchar(255) default NULL,
  `vlanID` int(11) default NULL,
  `port_A` varchar(255) default NULL,
  `OA_IP_A` varchar(255) default NULL,
  `popID_A` int(11) default NULL,
  `CID` varchar(255) default NULL,
  `pop_ID_Z` int(11) default NULL,
  `OA_IP_Z` varchar(255) default NULL,
  `port_Z` varchar(255) default NULL,
  `service_desc` varchar(255) default NULL,
  `customer_location` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `pops` (
  `popID` int(11) NOT NULL,
  `POPS` varchar(75) NOT NULL,
  `Network_Address` varchar(25) NOT NULL,
  PRIMARY KEY  (`popID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;