表a
id int
content varchar(200)
flag int
表b
id int
userID int
tel varchar(10)
flag int
insert into a values(1,'Nice to Meet you!',0)
insert into b values(1,123,'13812345678',0)
insert into b values(2,124,'13912345678',0)
insert into b values(3,125,'13712345678',0)
要求得到结果
13812345678 Nice to Meet you!
13912345678 Nice to Meet you!
13712345678 Nice to Meet you!
但是如果 表中flag都为1 则无结果
例如：
insert into a values(1,'Nice to Meet you!',1)
insert into b values(1,123,'13812345678',0)
insert into b values(2,124,'13912345678',0)
insert into b values(3,125,'13712345678',0)
查询无结果
insert into a values(1,'Nice to Meet you!',0)
insert into b values(1,123,'13812345678',1)
insert into b values(2,124,'13912345678',0)
insert into b values(3,125,'13712345678',0)
结果只有俩条
13912345678 Nice to Meet you!
13712345678 Nice to Meet you!
我这么写了
SELECT b.tel,content
from a left JOIN
b on a.flag=0 and b.flag =0
但是 如果
现在有两张表：文章主表A(articleId,articleTitle)，文章评论表B(commentId,articleId,commentTitle)
现在我想实现这样的功能：列出文章列表，其中每篇文章标题下面列出此文章的前2个文章评论，请问sql语句怎么写啊 ......
