求 SQL语句,在线等

[掌鑫磊外包]

两个表letter留言表 replyletter回复表,letter表有keyword属性,replyletter有replyID属性.
现在要在replyletter表中查询所有replyID=keyword的记录.
本人是初学者,谢谢大侠

[purple_tide]

letter replyletter 通过哪个字段管理?

[purple_tide]

letter replyletter 通过哪个字段关联?

[userwjg]

select * from replyletter where c_reply in (select keyword from letter)

[skyaspnet]

  select replyletter的字段名(如果有与letter表重复的字段名,在前面加A., 相当于 A.字段名) from letter A, replyletter B where A.replyID=B.replyletter

[xxgu]

select letter.*,replyletter.* from replyletter where replyletter.replyID=letter.keyword

[skyaspnet]

改正一下

select replyletter的字段名(如果有与letter表重复的字段名,在前面加B., 相当于 B.字段名) from letter A, replyletter B where A.keyword=B.replyID

[酸黄瓜]

select *
from replyletter left join letter on replyletter.replyID=letter.keyword

[appley]

select * from replyletter,letter where replyletter.c_reply =letter.keyword

[yb1124]

select r.* from replyletter r,letter l
where r.replyID=l.keyword

[掌鑫磊外包]

不好意思,还有个条件,letter的表中的keyword=latel1.text

[yb1124]

string sql="select r.* from replyletter r,letter l where r.replyID=l.keyword and l.keyword='"+latel1.text+"'";

[yb1124]

string sql="select r.* from replyletter r,letter l where r.replyID=l.keyword and l.keyword=[color=#FF0000]'"+latel1.text+"'";[/color]

[tltulei]

select *
from replyletter inner join letter on replyletter.replyID=letter.keyword

[callmekobe]

"select * from replyletter where c_reply in (select keyword from letter where keyword='"+latel1.text+"')";

[milizi820]

[Quote=引用 11 楼 yb1124 的回复:]
string sql="select r.* from replyletter r,letter l where r.replyID=l.keyword and l.keyword='"+latel1.text+"'";
[/Quote]