New columns like subquery

Hi, I simply need to achieve as shown in picture. In sql I would simply write   select c.customer ,(select e.product_id from product e where e.product_id = c.product_id and e.productgroup = 'Elce...