----- Original Message ----- From: "Rob Wultsch" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Cc: "MYSQL General List" <[email protected]> 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 <[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) ----- 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; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
