hi ppl...

i hav a table with MANY columns...
A SAMPLE TABLE FOR MY QUERY WILL LOOK AS FOLL......

NAME LEVEL ID

Jim P 1
Jim V 2
Peter P 3
Peter S 4
Peter E 5
Peter V 6


many records in the table follow this sequence with some having to
levels and some having four levels.


how can i write a query to display all with level 'E' (which is simple)
but also include the level 'P'. however i only want to display records
where the level 'P' has level V(refer to JIM)

so if i was to query this sample table .... my output would be as
follows...


NAME LEVEL ID

Jim P 1
Peter E 5


thx in advance