query error

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
bugthefixer
Forum Contributor
Posts: 118
Joined: Mon Mar 22, 2004 2:35 am

query error

Post by bugthefixer »

Not unique table/alias

what does that error mean
User avatar
CoderGoblin
DevNet Resident
Posts: 1425
Joined: Tue Mar 16, 2004 10:03 am
Location: Aachen, Germany

Post by CoderGoblin »

Unless you are more specific and provide more detail (what are you doing when you the error occurs) it is difficult to help.

Three thoughts...
1) You are creating a table which already exists.
2) You are unknowingly using a reserved word for something.
3) That you are trying to put information into a table column where the column definition is set to unique. This means that any value may only appear once (Primary keys for instance).
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

sounds more to me, like you tried creating an alias that already existed, either in your query, or elsewhere..
Serberus
Forum Newbie
Posts: 5
Joined: Fri Aug 13, 2004 6:31 pm
Location: Hertfordshire, UK

Post by Serberus »

Are you performing a join between tables?
Post Reply