mysql 查询某值是否存在于某结果集或表中

SELECT
	*,
	(
		CASE
		WHEN m.id IN (
			SELECT
				id
			FROM
				table_b
			WHERE
				xxxxxx
		) THEN
			'Y'
		ELSE
			'N'
		END
	) AS status
FROM
        table_a

　　

转载于:https://www.cnblogs.com/zwsblogs/p/9165711.html