I need to create a query to exclude the value AD and NG out of my results.
My query that I created is not working. I still see NG in the file. I played around witht he or but still now working the way it should. I still see an NG in the clm_att1 field.
clm_id1, clm_84b , clmx_50b3, clm_dout, clm_tchg, clm_nego, clm_sppo, clm_lnet, clm_att1, clm_att2, clm_att3, clm_att4, clm_att5
left join impact.dbo.clmx on clmx_id1 = clm_id1
clm_att5 = '!P' and clm_dout between '01/01/2018' and '12/31/2018' and
(clm_att1 NOT IN ('AD','NG') or clm_att2 NOT IN ('AD','NG') or clm_att3 NOT IN ('AD','NG') or clm_att4 NOT IN ('AD','NG') )