极限优化

一、过滤查询A表中B表已经存在的

SELECT
	t1.*
FROM
	project_info t1 
WHERE
	( SELECT COUNT( 1 ) FROM project_publicity_project t2 WHERE t1.Id = t2.project_id ) = 0;