Can’t Get My JOINs Right for this Query
SELECT message.Id, 
       message.message,
       message.category,
       person.Id personId, 
       CASE WHEN personmessage.messageId IS NULL 
            THEN 0 
            ELSE 1
            END enabled 
FROM message
CROSS JOIN person
LEFT JOIN personmessage ON personmessage.personId = person.Id
                       AND personmessage.messageId = message.Id
ORDER BY 4,1


fiddle