select g.id,number,g.name,c_Id,u_Id,c.name as category.u.name as users from Goods as g,Category as c,Users as u where c.id=c_Id and u.id=u_Id
运行时:
提示错误:消息 258,级别 15,状态 1,第 1 行
不能对 varchar 调用方法。
出现这个错误是因为“,”写成了“.”
改为:
select g.id,number,g.name,c_Id,u_Id,c.name as category,u.name as users from Goods as g,Category as c,Users as u where c.id=c_Id and u.id=u_Id