一张表 SELECT hb_client.* FROM hb_client INNER JOIN hb_client_sign ON hb_client.id = hb_client_sign.classid AND hb_client_sign.tgxm='20' AND hb_client.state = '2' AND hb_client.oper='xxx' AND import !=1 GROUP BY hb_client.company ORDER BY hb_client_sign.opr_time DESC 可以SELECT hb_client.* FROM hb_client INNER JOIN hb_client_sign ON hb_client.id = hb_client_sign.classid AND hb_client.state = '2' AND hb_client.oper='xxx' AND import !=1 GROUP BY hb_client.company ORDER BY hb_client_sign.opr_time DESC LIMIT 0,80 不行
SELECT hb_client.* FROM hb_client INNER JOIN hb_client_sign ON hb_client.id = hb_client_sign.classid AND hb_client_sign.tgxm='20' AND hb_client.state = '2' AND hb_client.oper='xxx' AND import !=1 GROUP BY hb_client.company ORDER BY hb_client_sign.opr_time DESC 可以SELECT hb_client.* FROM hb_client INNER JOIN hb_client_sign ON hb_client.id = hb_client_sign.classid AND hb_client.state = '2' AND hb_client.oper='xxx' AND import !=1 GROUP BY hb_client.company ORDER BY hb_client_sign.opr_time DESC LIMIT 0,80 不行