When using NOT IN you should ensure that none of the values are NULL:
SELECT status, creation_date
FROM logs
WHERE logs_type_id=11
AND status NOT IN (
SELECT status
FROM consols
WHERE status IS NOT NULL -- add this
)
When using NOT IN you should ensure that none of the values are NULL:
SELECT status, creation_date
FROM logs
WHERE logs_type_id=11
AND status NOT IN (
SELECT status
FROM consols
WHERE status IS NOT NULL -- add this
)