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 be

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" > Sent: Friday, May 23, 2008 11:10:56 AM GMT -08:00 US/Canad

Re: Query Output Issue

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

Re: Query Output Issue

2008-05-23 Thread mdimartino
- Original Message - From: "Rob Wultsch" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Cc: "MYSQL General List" 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 PROTEC

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.pop

Re: Query Output Issue

2008-05-23 Thread mdimartino
Canada Pacific 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 pop

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
US/Canada 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 > Ci

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 >

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 circuits.Z_