Unknown column 'list.c_id' in 'where clause'

todayhero

这个语句报错,如何解决此问题

select b.c_id from list a,cate b where list.c_id=cate.c_id;

wildlily980

select b.c_id from list a,cate b where a.c_id=b.c_id;

todayhero

原帖由 wildlily980 于 2009-2-6 12:54 发表
select b.c_id from list a,cate b where a.c_id=b.c_id;

THX

原来我没有注意写错了.平时用的太少.