Re: MySql5 problem
Hi,
I think you swapped the ON clauses in the query. You wrote:
...FROM person_person AS t INNER JOIN person AS r ON (p.person_id = t.person_id) INNER JOIN person AS p ON (r.person_id = t.related_person_id)...
In the first join you are linking tables t and r, but in the ON clause you have tables p and t.
Moreover, in the second join you are linking with table p but in the ON clause you have tables r and t.
Subject
Views
Written By
Posted
6292
July 06, 2007 01:00AM
3296
July 06, 2007 06:08AM
Re: MySql5 problem
3480
August 28, 2007 10:55AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.