Re: Not Unique Error

2004-10-25 Thread SGreen
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

Re: Not Unique Error

2004-10-23 Thread Gavin Barnard
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'