select con insert

[evoarte]

buenas noches,
así ha quedado:

SELECT DISTINCT [tabla1].[id] AS CampoId INTO tablax
FROM tabla1
WHERE tabla1.id IN (SELECT cod_id2 FROM tabla2) OR tabla1.id IN (SELECT cod_id3 FROM tabla3) OR tabla1.id IN (SELECT cod_id4 FROM tabla4);

parece ok
gracias.