摘要： 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 阅读全文