oracle8.1.6 select name, remove_threshold, nvl(sc.songs,0) as songs, mp.playlist_id from mp3_playlists mp, mp3_playlist_song_count sc where mp.playlist_id=:playlist_id and sc.playlist_id(+) = mp.playlist_id