- 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
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
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
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
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
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
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
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
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
- 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
10 matches
Mail list logo