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'
