select * from friend where userid =值friendid和user表有关系?不是很清楚两者之间的关系。
select *from friend where userid in(select userid from user where username='王明')
select * from friend A Join user B On A.userid=B.userid where userid =123
3L:回答很给力啊,在一个地方时可以用的,效果不错但是在另一个地方就出错了 select * from GROUP where GROUPid in(select GroupID from UserGroup where UserID= 'B08030224') ADO Error Code = 80040e14 Code meaning = IDispatch error #3092 Source = Microsoft OLE DB Provider for ODBC Drivers Description = [Microsoft][ODBC SQL Server Driver][SQL Server]关键字 'GRO UP' 附近有语法错误。 有人知道什么什么原因吗
from friend A
Join user B On A.userid=B.userid
where userid =123
select * from GROUP where GROUPid in(select GroupID from UserGroup where UserID=
'B08030224') ADO Error
Code = 80040e14
Code meaning = IDispatch error #3092
Source = Microsoft OLE DB Provider for ODBC Drivers
Description = [Microsoft][ODBC SQL Server Driver][SQL Server]关键字 'GRO
UP' 附近有语法错误。
有人知道什么什么原因吗