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