Page 1 of 1
query error
Posted: Thu Aug 12, 2004 3:35 am
by bugthefixer
Not unique table/alias
what does that error mean
Posted: Thu Aug 12, 2004 3:51 am
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).
Posted: Thu Aug 12, 2004 10:52 am
by feyd
sounds more to me, like you tried creating an alias that already existed, either in your query, or elsewhere..
Posted: Fri Aug 13, 2004 6:55 pm
by Serberus
Are you performing a join between tables?