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 s
SELECT u.UserName, u.userID, u.lastip, u.totallogins, u.lastbrowser,
u.lastlogin, u.Password, u.person, u.entryid, u.namerep, u.countryid,
c.countryid, c.image,
c.countryid, c.country
FROM Users as u, Country as c INNER JOIN Country as cc ON
cc.countryid = u.countryid
WHERE UserName = 'angelica'
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.u
