----- 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: > 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 guess I am mindreader cause you did not post your error message. I really should hire myself at higher fees with this new found ability. Please stop: Top posting. Most lists either top post or bottom post, and some mix. This list mixes a small amount, but generally bottom post. When in doubt I follow the convention of the first response. Posting the relationship. Posting your table create syntax on the other hand would be useful. -- Rob Wultsch [EMAIL PROTECTED] ----- Original Message ----- SQL query: Documentation SELECT l1.POPS AS `POPA` , l2.POPS AS `POPZ` FROM circuits INNER JOIN pops.POPS AS p1 WHERE circuits.popID_A = l1.popID INNER JOIN pops.POPS AS p2 WHERE circuits.pop_ID_Z = l2.popID LIMIT 0 , 30 MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN pops.POPS as p2 WHERE circuits.pop_ID_Z =l2.popID LIMIT 0, 30' at line 7 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
