sql :
SELECT *
FROM [KQDATA].[dbo].[SHOP]
where [SHOP_FABU]=1 and [SHOP_ENABLE]=0
order by (case when [SHOP_CIRCLE_ID]=2 then 1 else 2 end) ,shop_id desc;
access:
select top 9 SHOP_ID,SHOP_NAME_CHS,SHOP_MULTIMEDIA_LOGO,SHOP_CIRCLE_ID from shop where shop_enable=0 and shop_fabu=1 order by (iif( SHOP_CIRCLE_ID=" + ac.Areaid + " , 1 , 2 ) ),SHOP_FABUTIME, SHOP_ID desc