点播记录查询
select mobileNo,sendTime from (select substring(convert(char(50),mobileNo),1,7)as mobileNo,sendTime from dbo.SmsSendRecord) a
where a.mobileNo in (select convert(char(50),mobileNo) from Table_3 where code=832)
and a.sendTime between '2009-6-8' and '2009-6-14'
where a.mobileNo in (select convert(char(50),mobileNo) from Table_3 where code=832)
and a.sendTime between '2009-6-8' and '2009-6-14'
