05-13-2013 05:01 PM
Create table mkt1 as
from datamart1 a
left join States b
where (a.subcategory in (‘F’,’N’) and
balance1 >0 and
(a.status_cd ne ‘S’ and a.status_cd ne ‘Y’) and
(a.template1 ne ‘X’ and a.template1 ne ‘G’));
I ran this code above. In checking the data, it did not eliminate the status_cd of 'S' or 'Y'. I then took out the brackets for the status_cd and reran it. It is running forever now and will not stop. I want to eliminate the status_cd and the template1 that I have specified. The brackets are balanced so how come they fo not eliminate?
Need further help from the community? Please ask a new question.