SELECT * FROM tabla1 WHERE ID LIKE '10%' and ID NOT IN (SELECT clave FROM tabla2 WHERE condicion= '2' )