帮看看
select c.cpzh,m.wzsj_sn, m.wzsj,b.name,m.yxbz,m.clbj from
(select * from takeout ,peccancy where takeout.dzjk_sn=peccancy.wzsj_sn) m,
vehicle c , standernote b where c.cpzh='苏GD9891' and c.hpzl='02'
and (substr(m.wzdd,1,5)=b.id) and c.cpz_sn=m.cpz_id order by m.wzsj desc运行说未明确定义列 我想让select * from takeout ,peccancy where takeout.dzjk_sn=peccancy.wzsj_sn查询出的表为m表 再和另外两个表联合查询出结果 这么写错了怎么改啊?
select c.cpzh,m.wzsj_sn, m.wzsj,b.name,m.yxbz,m.clbj from
(select * from takeout ,peccancy where takeout.dzjk_sn=peccancy.wzsj_sn) m,
vehicle c , standernote b where c.cpzh='苏GD9891' and c.hpzl='02'
and (substr(m.wzdd,1,5)=b.id) and c.cpz_sn=m.cpz_id order by m.wzsj desc运行说未明确定义列 我想让select * from takeout ,peccancy where takeout.dzjk_sn=peccancy.wzsj_sn查询出的表为m表 再和另外两个表联合查询出结果 这么写错了怎么改啊?
select * 最好指定 字段名 和别名
from takeout, peccancy
where takeout.dzjk_sn = peccancy.wzsj_sn这个语句里,你不要用 * 号,把要用的字段具体的写出来,而且要写明是那张表的字段