Home Forums SQL Server 7,2000 T-SQL SQL statement RE: SQL statement
NPeeters
SSChampion
Points: 12358
More actions
August 19, 2003 at 5:37 am
#470392
I guess you are looking for a AND in the query.
Try this
SELECT Student FROM TableA M WHERE EXISTS (SELECT 1 FROM TableA S1 WHERE S1.Student = M.Student AND S1.NumberOfTests >= 2 AND S1.Percent >= 30) AND M.NumberOfTests >= 1 AND M.Percent >= 40