... something like this:
SELECT
A.ContactID,
B.CASLOptIN,
B.CASLOptOut,
B.CASLException
FROM
Contact A INNER JOIN GE_ContactInfo B
ON A.CONTACTID=B.CONTACTID
WHERE
A.Accountid ='XXXXXXXXXX'
AND
(
(B.CASLOptOut ='F' or B.CASLEXCEPTION is null)
OR
(B.CASLEXCEPTION ='F' or B.CASLEXCEPTION is null)
)
Hope it helps.