Query Exclude data

[epkiran]

I want to exclude a value,

in this case list all students with lastname Andersson
and where firstname is not Irene.


SELECT name
FROM student
WHERE lastname='andersson' and firstname is not Irene???

What do I do?

 

[WingandaPrayer]

This is a quick amatuerism attempt.

SELECT tblStudentsNames.FirstName, tblStudentsNames.LastNameSurname
FROM tblStudentsNames
GROUP BY tblStudentsNames.FirstName, tblStudentsNames.LastNameSurname
HAVING ((Not (tblStudentsNames.FirstName)=[enter firstname]) AND ((tblStudentsNames.LastNameSurname)=[enter surname]))


HTH

David

 

[JoeMiller]

Try this out:

SELECT name
FROM student
WHERE lastname = 'andersson' AND firstname <> 'Irene';

That should do it Joe Miller
joe.miller@flotech.net