sql查找排除某些表后不存在某个字段的表

SELECT table_name FROM information_schema.tables
WHERE table_schema='database_name'
	AND table_name NOT LIKE 'table_name'
	AND table_name NOT IN(SELECT col.table_name  FROM information_schema.`COLUMNS` col
	       WHERE col.table_name IN (SELECT table_name FROM information_schema.tables
					WHERE table_schema='database_name'
					AND table_name NOT LIKE 'table_name'
					AND col.column_name='gmt_modified');