Re: Query Output Issue

2008-05-24 Thread mdimartino
- Original Message - From: Rob Wultsch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: MYSQL General List mysql@lists.mysql.com 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

Re: Query Output Issue

2008-05-24 Thread Rob Wultsch
On Fri, May 23, 2008 at 3:06 PM, [EMAIL PROTECTED] wrote: - Original Message - From: Rob Wultsch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: MYSQL General List mysql@lists.mysql.com Sent: Friday, May 23, 2008 11:10:56 AM GMT -08:00 US/Canada Pacific Subject: Re: Query Output Issue

Re: Query Output Issue

2008-05-24 Thread Rob Wultsch
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

Query Output Issue

2008-05-23 Thread mdimartino
I have a table that has two has two secondary keys referencing the same primary key of another. Table-name =Circuits circuitID CircuitID A_loc Z_loc Table-name = Location locationID location circuits.A_locreferenceslocatioin.locationID

Re: Query Output Issue

2008-05-23 Thread Rob Wultsch
On Fri, May 23, 2008 at 11:27 AM, [EMAIL PROTECTED] wrote: I have a table that has two has two secondary keys referencing the same primary key of another. Table-name =Circuits circuitID CircuitID A_loc Z_loc Table-name = Location locationID location

Re: Query Output Issue

2008-05-23 Thread mdimartino
Pacific Subject: Re: Query Output Issue On Fri, May 23, 2008 at 11:27 AM, [EMAIL PROTECTED] wrote: I have a table that has two has two secondary keys referencing the same primary key of another. Table-name =Circuits circuitID CircuitID A_loc Z_loc Table-name

Re: Query Output Issue

2008-05-23 Thread Rob Wultsch
On Fri, May 23, 2008 at 12:04 PM, [EMAIL PROTECTED] wrote: Thanks for the quick reply, however i am getting a failure on line 2. SELECT 11.POPS AS `POPA`, 12.POPS AS `POPZ` FROM circuits INNER JOIN pops.POPS as 11 WHERE circuits.popA = 11.popID INNER JOIN pops.POPS as 12 WHERE

Re: Query Output Issue

2008-05-23 Thread mdimartino
Subject: Re: Query Output Issue On Fri, May 23, 2008 at 12:04 PM, [EMAIL PROTECTED] wrote: Thanks for the quick reply, however i am getting a failure on line 2. SELECT 11.POPS AS `POPA`, 12.POPS AS `POPZ` FROM circuits INNER JOIN pops.POPS as 11 WHERE circuits.popA = 11.popID INNER JOIN

Re: Query Output Issue

2008-05-23 Thread Rob Wultsch
On Fri, May 23, 2008 at 1:47 PM, [EMAIL PROTECTED] wrote: Still getting and error on the last line 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 I

Re: Query Output Issue

2008-05-23 Thread mdimartino
- Original Message - From: Rob Wultsch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: MYSQL General List mysql@lists.mysql.com Sent: Friday, May 23, 2008 11:10:56 AM GMT -08:00 US/Canada Pacific Subject: Re: Query Output Issue On Fri, May 23, 2008 at 1:47 PM, [EMAIL PROTECTED] wrote