You are INNER JOINING the country table to the query twice without giving the query separate aliases for each. Also, you are providing only one set of join conditions so you are going to make a Cartesian product with one of those joins.
Looks to me like you only need the table once. Here's my suggestion: SELECT users.UserName, users.userID, users.lastip, users.totallogins, users.lastbrowser, users.lastlogin, users.Password, users.person, users.entryid, users.namerep, users.countryid, country.countryid, country.image, country.countryid, country.country FROM Users INNER JOIN Country ON country.countryid = users.countryid WHERE UserName = 'angelica' AND Password = '4598734' Shawn Green Database Administrator Unimin Corporation - Spruce Pine "EWA Goodson-Wickes" <[EMAIL PROTECTED]> wrote on 10/23/2004 09:32:24 PM: > Hi all, > I am using Navicat to connect to my MySQL database. I get the > following error when I try a query even though there is only one > table called Country. Why do I get this error? Thank you for any advice > > Error: 1066 Not Unique Table/Alias Country > > QUERY: > SELECT users.UserName, users.userID, users.lastip, users. > totallogins, users.lastbrowser, > users.lastlogin, users.Password, users.person, users.entryid, users. > namerep, users.countryid, > country.countryid, country.image, > country.countryid, country.country > FROM Users, Country INNER JOIN Country ON country.countryid = > users.countryid > WHERE UserName = 'angelica' > AND Password = '4598734'
