把多表联查的sql语句转换成linq语句

Question

SELECT * FROM [group_product]
where proid in(select proid from [group_browsehistory]
where memid in(select memid from [group_browsehistory] where proid=12))

在线等，这个sql语句怎么转换成linq？？？

Answer 1

最好加上top 和 order by 如下：
SELECT top(2)* FROM [group_product]
where proid in(select proid from [group_browsehistory]
where memid in(select memid from [group_browsehistory] where proid=12))
order by apptime desc

我是想获取浏览过proid=12的商品的人浏览过的其他商品。