mysql 查询一个表中有的记录且在另一个表中无相关的记录sql

1、

SELECT
	*
FROM
	table1
WHERE
	xxx
and fieldsname not in (
	SELECT fieldsname from table2 where xxxx)
);
SELECT
	*
FROM
	table1
WHERE
	xxx
and f