可以试一下这句:SELECT [上级表].name(这里写上需要显示的部分内容) FROM [上级表] INNER JOIN [本表] ON [上级表].Id = [本表].followid WHERE ([本表].type = 1)也可以试试这个语句 SELECT * FROM [上级表] WHERE Id IN (SELECT [本表].followid FROM [本表] WHERE ([本表].type = 1))
这些数据都在一个表中,用type来进行区别.我现在不清楚SQLSERVER里面的记录集是怎么表示的?比如select id,name,sex from user,我如何循环读出name字段的内容?在存储过程中.
FROM [上级表] INNER JOIN
[本表] ON [上级表].Id = [本表].followid
WHERE ([本表].type = 1)也可以试试这个语句
SELECT *
FROM [上级表]
WHERE Id IN (SELECT [本表].followid
FROM [本表]
WHERE ([本表].type = 1))