Gentlemen, I have a table where I want to bring the column when the value is null but when it is filled it should not be displayed, how can I implement this condition in SQL?
SELECT
OBS.NUOBS,
OBS.DTOBS,
OBS.CODUSU,
OBS.OBS,
OBS.PENDENTELOG,
OBS.DTHSOBS,
OBS.REGINC,
OBS.DHPROXCONTATO,
OBS.ID,
OBS.FIMATT
FROM AD_PRONTUARIOOBS OBS
LEFT JOIN AD_PRONTUARIOATT ATT (NOLOCK) ON ATT.PEDIDOEXTERNO = OBS.PEDIDOEXTERNO
Now I'm developing the above query, column B would refer to table AD_PRONTUARIOATT