There are multiple lines (sequenced) of my records in a table with the same Key.
Example of the table Student No. Name Grade 1001 Michelle Fail 1001 Michelle Fail 1025 Peter Fail 1025 Peter Pass 1025 Peter Pass
I want to query Students with no Pass meaning. Select Student No. Where Grade = Fail and Student No. not in (Grade = Pass)
I can write it in SQL but how can I write this nested query in Select records of AS/400?
November 26, 2009 11:19 AM
November 30, 2009 9:41 PM