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' ;
> 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
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)