语句如下:
select top 6 * from Member_Product where mp_commend=2 and mp_member not in (select mb_id from member_table where mb_isvip=1) order by Mp_Id desc
请求帮助
建立索引我会的,但建立视图我还不会,如果建立视图比较好,请说明下步骤
谢谢!
select top 6 * from Member_Product where mp_commend=2 and mp_member not in (select mb_id from member_table where mb_isvip=1) order by Mp_Id desc
请求帮助
建立索引我会的,但建立视图我还不会,如果建立视图比较好,请说明下步骤
谢谢!
as
select top 6 * from Member_Product where mp_commend=2 and mp_member not in (select mb_id from member_table where mb_isvip=1) order by Mp_Id desc
as
select top 6 * from Member_Product where mp_commend=2 and mp_member not in (select mb_id from member_table where mb_isvip=1) order by Mp_Id desc