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