Re: simple problem - error 1066 Not Unique table/alias and Conditional

[Phillip Ward]

So near ...

SELECT place.name AS place_name 
, p1.name AS name1 
, p2.name AS name2 
FROM place 
INNER JOIN person AS p1 
      ON   place.id_person1 = p1.id_person 
INNER JOIN person AS p2 
      ON   place.id_person2 = p2.id_person

Regards, Phill W.