I would like your help in Query below:
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)
Example:
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)