select record_id from lookup where name in ('JOHN', 'SMITH') group by record_id