Forum OpenACS Development: Response to Outer join fun

In the original query, "v" is the name given to the subselect that's the right operand of your first outer join. You don't need two outer joins, here. The Oracle form is joining on two keys is all, it's just one join. So something like:

create view mp3_mp3_playlist_map_view as
  select m.mp3_id,
         m.playlist_id,
         ..etc...
  from mp3_mp3_playlist_map m
       left join (select ...your subselect ...)
       using (mp3_id, playlist_id);

should be sufficient.