oracle8.1.6 select name, mp.playlist_id, nvl(sc.songs,0) as songs from acs_objects, mp3_playlists mp, mp3_playlist_song_count sc where object_id = mp.playlist_id and context_id = :package_id and mp.playlist_id = sc.playlist_id(+) order by name