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???
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???
最好加上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的商品的人浏览过的其他商品。