This seems to be working but it is grouping the 'service code' from Table 2 - I need to show all the rows from table 2 with the Match at the end. SELECT foo.'service code', NVL2(l.SERVICECODE, 'Y', '… (View Post)