How do I exclude two question codes from the following query?
Summary:
Unfortunately I do not know SQL and am struggling with what I would think is a simple ask. I am trying to exclude two question codes from a query that I have.
Content (please ensure you mask any confidential information):
Please see the query below:
SELECT
a.question_code
,b.question_text AS Question
,c.name AS Response_Type
,d.score
,e.long_text AS Answer
,d.answer_code
FROM
hrq_questions_b a
,hrq_questions_tl b
,hrq_response_types_tl c
,hrq_qstn_answers_b d
,hrq_qstn_answers_tl e
WHERE 1=1
AND a.question_code LIKE 'MAYO_USJS_Q%'