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: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
Your using WHERE instead of ON. Not sure why I did not see that earlier... SELECT l1.POPS AS `POPA` , l2.POPS AS `POPZ` FROM circuits INNER JOIN pops.POPS AS p1 ON circuits.popID_A = l1.popID INNER JOIN pops.POPS AS p2 ON circuits.pop_ID_Z = l2.popID LIMIT 0 , 30 http://dev.mysql.com/doc/refman/5.0/en/join.html -- Rob Wultsch [EMAIL PROTECTED] wultsch (aim) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]