You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How do I exclude two question codes from the following query?

Accepted answer
14
Views
2
Comments

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%'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!