2013年6月19日
同一张表里面查询不同的内容比较
摘要： SELECT b.* FROM(SELECT ip,DATE_FORMAT(FROM_UNIXTIME(createtime),"%Y%m%d") AS createtime FROM InApp_AdLog WHERE appid=6 AND bgtype=1 ) AS a, (SELECT ip,DATE_FORMAT(FROM_UNIXTIME(createtime),"%Y%m%d") AS createtime FROM InApp_AdLog WHERE appid=6 AND bgtype=2 ) AS bWHERE a.ip=b.ip G 阅读全文
posted @ 2013-06-19 11:04 jshaibozhong 阅读(195) 评论(0) 推荐(0)