So, first you had too many records, now too little of them. Well, that indicates that there is one more problem with your code. Can you do the query without the WHERE line? Does it give the records that you want in your result?

>Putting that statement in the where line, gets me no results found. There should be 5 records coming back.
>
>Thanks anyway.
>
>>I don't understand why stu.enrollment_status <> 'INACTIVE' should be part of the JOIN. Rather, it should be in the WHERE clause:

>>   FROM students AS stu ;
>>   LEFT JOIN addresses AS adr ;
>>   ON stu.student_id = adr.student_id AND ;
>>   stu.school_year = adr.school_year ;
>>   WHERE stu.enrollment_status <> 'INACTIVE' ;

>>
>>
>>
>>>Hi all,
>>>
>>>I have the following sql select sting that is bringing over records that do not match the commented line.
>>>
>>>

>>> SELECT stu.student_id, stu.school_year, last_name, first_name, ;
>>>   current_school, grade_level, gender_code, session_code, ;
>>>   padl(day(date_of_birth),2,"0") as dd________, ;
>>>   padl(month(date_of_birth), 2,"0") as mm________, ;
>>>   year(date_of_birth) as yy________, ;
>>>   address_mailing_line_1, address_city, state_code, ;
>>>   address_zipcode, address_name, address_type_code ;
>>>   FROM students AS stu ;
>>>   LEFT JOIN addresses AS adr ;
>>>   ON stu.student_id = adr.student_id AND ;
>>>   stu.school_year = adr.school_year ;
>>>   and stu.enrollment_status <> 'INACTIVE' ;  && This line
>>>   INTO CURSOR cstuadr nofilter
>>>

>>>The sql brings the records over even if the enrollment_status = 'inactive'
>>>
>>>What am I missing?
>>> I had that line as a where line, but then the sql does not bring any records over. I have 5 Active and 1 inactive students that I am working with at the moment.
>>>
>>>TIA
>>>Beth