Sorry forgot to CC my other reply. Left join causes it. Move that partt to where clause.
Cetin
>No, unfortunately it does not. The way this is going, I may just have to have another sql statement before this on that grabs all students that are not inactive and continue with the result table.
>
>Thanks for the help.
>Beth
>>
>>Beth,
>>Considering "inactive" casing is right in your code, might it be that returned rows with "INACTIVE" are something like [whitespace or nonprintablechar]+"INACTIVE"?
>>(or with set ansi on after INACTIVE has chars that's not a space).
>>
>>Does
!(ltrim(stu.enrollment_status) == 'INACTIVE')
help?
>>Cetin