古剑

在商品栏目搜索同城商品时出错，请问是什么原因？

SQL: SELECT * FROM [Table]spaceitems i, [Table]spacegoods g WHERE i.type='goods' AND g.itemid=i.itemid AND g.province = '湖北' AND g.city = '黄石' ORDER BY itemid DESC LIMIT 0,100
Error: Column 'itemid' in order clause is ambiguous
Errno.: 1052