select * from t_goods left join t_depot_d on t_goods.itemno = t_depot_d.itemno where vendorno='20441'服务器: 消息 209,级别 16,状态 1,行 1 列名 'vendorno' 不明确。
select * from t_goods left join t_depot_d on t_goods.itemno = t_depot_d.itemno where t_depot_d.vendorno='20441' 要加上表名
指定表呀。 如: select t_goods.* from t_goods left join t_depot_d on t_goods.itemno = t_depot_d.itemno where t_depot_d.vendorno='20441'或用别名也可以。 select a.* from t_goods left a join t_depot_d b on t_goods.itemno = t_depot_d.itemno where b.vendorno='20441'
列名 'vendorno' 不明确。
from t_goods left
join t_depot_d on t_goods.itemno = t_depot_d.itemno
where vendorno='20441'服务器: 消息 209,级别 16,状态 1,行 1
列名 'vendorno' 不明确。
from t_goods left
join t_depot_d on t_goods.itemno = t_depot_d.itemno
where t_depot_d.vendorno='20441'
要加上表名
如:
select t_goods.*
from t_goods left
join t_depot_d on t_goods.itemno = t_depot_d.itemno
where t_depot_d.vendorno='20441'或用别名也可以。
select a.*
from t_goods left a
join t_depot_d b on t_goods.itemno = t_depot_d.itemno
where b.vendorno='20441'