SQL query to reduce the conditions in where clause

santohsks1987 · New User Joined: 29 Dec 2010 Posts: 31 Location: Mumbai

Hi everyone,

I have a SQL query.

EXEC SQL
SELECT FIRST_NM, REL_CD, BIRTH_DT
FROM T_NEUT_MBR
WHERE REL_CD NOT = ‘E’
AND ((FIRST_NM = WS-FIRST-NAME(SUB)
AND (REL_CD = WS-REL-CD(SUB)
OR BIRTH_DT = WS-BIRTH_DT(SUB)))
OR (REL_CD = WS-REL_CD(SUB)
AND (FIRST_NM = WS-FIRST-NAME(SUB)
OR BIRTH_DT = WS-BIRTH_DT(SUB)))
OR (BIRTH_DT = WS-BIRTH_DT(SUB)
AND (FIRST_NM = WS-FIRST-NAME(SUB)
OR REL_CD = WS-REL-CD(SUB))))
END-EXEC.

here i actually have to reduce the conditions in where clause..... can u suggest me how to do it.

This conditions actually signify that there are three conditions and only 2 out of three conditions have to satisfy it. so i have done permutation and combination to get 9 conditions.

GuyC · Posted: Tue Jan 11, 2011 1:23 pm

santohsks1987 · New User Joined: 29 Dec 2010 Posts: 31 Location: Mumbai

Thank you for the reply..... so this code satisfies my requirement na.....