Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: SQL INNER JOIN query
11-05-2007, 09:40 PM #1
- Join Date
- Jan 2007
- Thanked 0 Times in 0 Posts
SQL INNER JOIN query
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
Unknown column 'usershop.ID' in 'on clause'
I checked my table, usershop and it does have a collumn ID. So what's wrong :X?