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

Reiro wrote:
> 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

So what have you tried? While you are trying it yourself, consider
these hints:
* self join
* outer join

Can you build a query that returns all the rows that match the P with a
V criteria?

show us a sample of your code (ORACLE version is always helpful
information)

HTH,
ed

hi i have found a way to find the P.... where there have a V and then
display all the E level's from the table....

Reiro wrote:
> hi i have found a way to find the P.... where there have a V and then
> display all the E level's from the table....

Care to post your solution?
ed

My actual table has diff columns .. just sum of the columns needed for
my query are used.


select asset_id, content_title, asset_level
from asset_temp
where content_title not in
(select t.content_title from asset_temp t where t.asset_level =
'E') and
asset_level = 'P'
union
select asset_id, content_title, asset_level
from asset_temp
where asset_level = 'E'