好像没搞定,
表名称实际上是finishitem和owner
联接列名ItemOwner
SELECT finishitem.ItemName,owner.Name FROM finishitem inner jion owner on finishitem.ItemOwner=owner.OwnerID
是否正确?
错误信息
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'jion owner on finishitem.ItemOwner=owner.OwnerID' at line 1