Re: sql query

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'