Selecting Records Based on 3 Criteria

[Mody]

I am trying to write a query that will select records based on three criteria.

Suppose we have a table like this :

ID Subject Mark
--------------------------------
1 English 56
1 Maths 62
1 Chemistry 96
2 English 49
2 Maths 65
3 English 87
3 Maths 78
3 Physics 45

Now i want to write a query that will select those IDs whose English and Maths mark both are 50 and above.

i would be very grateful if someone could help me as soon as possible.

Mody.

 

[Liv Manto]

ID Subject Mark
--------------------------------
1 English 56
1 Maths 62
1 Chemistry 96
2 English 49
2 Maths 65
3 English 87
3 Maths 78
3 Physics 45

Now i want to write a query that will select those IDs whose English and Maths mark both are 50 and above.

i would be very grateful if someone could help me as soon as possible.

Subject -------------------------------MARK
ENGLISH or MATHs-----------------------50 or >50



same row.