The stu.enrollment_status is from the left hand table. If it does not match, it should not come across.


>Perhaps the LEFT JOIN makes you get all records from the left side, even if there is no match on the right side. If this my suspicion is correct, the corresponding fields from the right-hand table should be NULL when there is no match.
>
>>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