Gostaria da ajuda de vocês na query abaixo:
SELECT C.*
FROM TB_CENTRAL C
WHERE EXISTS (SELECT DISTINCT 1
FROM TB_INTERMEDIARIA I
WHERE I.ID_ETA IN (16,24)
AND I.ID = C.ID)
Exemplo:
SELECT C.*
FROM TB_CENTRAL C
WHERE EXISTS (SELECT DISTINCT 1
FROM TB_INTERMEDIARIA I
WHERE I.ID_ETA IN (16)
AND I.ID = C.ID)