View Full Version : SQL INNER JOIN query

11-05-2007, 10:40 PM
Ok, i am running a query:

SELECT usershop.shopname, usershop.shopdesc, usershop.userid FROM `usershop` INNER JOIN `prem_usershop` ON `usershop.ID` = `prem_usershop.ID` ORDER BY `usershop.purchases` DESC LIMIT 0,10

And it returns this error:
Unknown column 'usershop.ID' in 'on clause'

I checked my table, usershop and it does have a collumn ID. So what's wrong :X?