SQL语法问题

[hxw19861121]

我想问我的SQL语句有错误吗？老实说from附近有语法错误。
string sql = "select newsupdates from tblnewsupdates b where b.intnewsupdatesid=a.intnewsupdatesid from tbllesson a";

[junlintianxia07]

肯定有错我啊 哪有这么写sql 的啊 “where b.intnewsupdatesid=a.intnewsupdatesid from tbllesson a";
”

[sjt000]

有错吧～
a.intnewsupdatesid from tbllesson a
这个不知道是想表达什么意思～

[zzxap]

string sql = "select a.newsupdates from tblnewsupdates b,tbllesson a where b.intnewsupdatesid=a.intnewsupdatesid ";

[cyz9977]

select newsupdates from tblnewsupdates b inner join tbllesson a on  b.intnewsupdatesid=a.intnewsupdatesid 

[zzxap]

好好看看书

[hxw19861121]

我创建了2个表1个是tbllesson
字段有
intlessonid，intnewsupdatesid
还有个表是tblnewsupdates
字段有intnewsupdatesid，newsupdates
tblnewsupdates表和tbllesson表关联起来。查询id能查询到newsupdates内容

[angellan]

[Quote=引用楼主 hxw19861121 的帖子:]
我想问我的SQL语句有错误吗？老实说from附近有语法错误。
string sql = "select newsupdates from tblnewsupdates b where b.intnewsupdatesid=a.intnewsupdatesid from tbllesson a";
[/Quote]

有错，你要不用连接，怎么可以有两个 from呢
应该用join 之类的

[lyly3530]

是联合查询吧


string sql="select * from tblnewsupdates b inner join tbllesson a on b.intnewsupdatesid=a.intnewsupdatesid"

你的语句没有指明newsupdates是哪张表的，b.newsupdates or a.newsupdates

[neu_dfh]

[Quote=引用 6 楼 hxw19861121 的回复:]
我创建了2个表1个是tbllesson
字段有
intlessonid，intnewsupdatesid
还有个表是tblnewsupdates
字段有intnewsupdatesid，newsupdates
tblnewsupdates表和tbllesson表关联起来。查询id能查询到newsupdates内容
[/Quote]
string sql = "select newsupdates from tblnewsupdates ,tbllesson where tbllesson.intnewsupdatesid ="" "" and tblnewsupdates.intnewsupdatesid=tbllesson.intnewsupdatesid ";