>How can I create an SQL statement that gets all records of one field value and the true condition of a second field or a not empty of a third field?
When in doubt, use parenthesis.
WHERE (field1="ABC" AND field2) OR NOT EMPTY(field3)
WHERE field1="ABC" AND (field2 OR NOT EMPTY(field3))
--sb--