补充我要的结果是显示2条记录
如下:
Aid UserName MeTitle MeContent MereleaseTime ADate
3 aaa aaa aaaa aaaaa aaa
3 bbb bbb bbbb bbbb bbbb
这条语句出来结果是:
6 aaa aaa aaaa aaaaa aaa
如下:
Aid UserName MeTitle MeContent MereleaseTime ADate
3 aaa aaa aaaa aaaaa aaa
3 bbb bbb bbbb bbbb bbbb
这条语句出来结果是:
6 aaa aaa aaaa aaaaa aaa
c.Aid,
UserName,
MeTitle,
MeContent,
MereleaseTime,
ADate
from UserInfo a,
Motif b,
Answer c,
(select count(*) Aid from Motif,Answer where Motif.MeId=Answer.MeId) d,
where b.UserId=a.UserId and b.MeId=c.MeId
?
select
(select count(*)Aid from Motif,Answer where Motif.UserId=a.UserId and Motif.MeId=Answer.MeId ),
UserName,
MeTitle,
MeContent,
MereleaseTime,
ADate
from UserInfo a ,Motif b,Answer c
where b.UserId=a.UserId and b.MeId=c.MeId
(
UserId int primary key identity, --用户ID流水号,主键,自增 UserName varchar(20) not null, --用户姓名
UserPwd varchar(20) not null, --用户密码
)create table Motif --主题表
(
MeId int primary key identity,
UserId int foreign key
references UserInfo(UserId),
--Tid int references MotifType(Tid),
MeTitle varchar(20) not null,
MeContent varchar(255) not null,
MeReleaseTime datetime not null,
)
go
create table Answer
(
Aid int primary key identity,
MeId int foreign key
references [Motif](MeId),
UserId int foreign key
references [UserInfo](UserId),
ADate datetime,
)
go