A select statement that uses: nvl, inner join, left outer join, and an array. Quick Reference