simple problem - error 1066 Not Unique table/alias
Probably an easy problem. Two tables. I want to select 2 names from Person table. I think a join table would be overboard for this simple requirement, let me know.
person (table)
- id_person
- name
place (table)
- id_place
- name
- id_person1 [fk person.id_person]
- id_person2 [fk person.id_person]
SELECT place.name AS place_name, person.name AS name1, person.name AS name2
FROM place
INNER JOIN person ON place.id_person1=person.id_person
INNER JOIN person ON place.id_person2=person.id_person
ERROR 1066 (42000): Not unique table/alias: 'person'
Wanting output as
place_name: "This Place"
name1: "Fname Lname"
name2: "Fname Lname"
tia
Subject
Written By
Posted
simple problem - error 1066 Not Unique table/alias
March 29, 2007 03:58PM
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.