Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table1 ( CUSTOMER_ID, FIRSTNAME, LASTNAME ) AS
  SELECT 1, 'ALICE', 'MILLER' FROM DUAL UNION ALL
  SELECT 2, 'BOB',   'SMITH' FROM DUAL;
2 rows affected

CREATE TABLE table2 ( ID, CUSTOMER_ID, TAG ) AS 
  SELECT 1, 1, 'PRO-CUSTOMER' FROM DUAL UNION ALL
  SELECT 2, 1, 'ADMIN' FROM DUAL UNION ALL
  SELECT 3, 2, 'PRO CUSTOMER' FROM DUAL;
3 rows affected

SELECT t1.customer_id,
       t1.firstname,
       t1.lastname,
       t2.tag1,
       t2.tag2,
       t2.tag3,
       t2.tag4
FROM   table1 t1
       LEFT OUTER JOIN
       (
         SELECT *
         FROM   ( SELECT customer_id, tag,
                         ROW_NUMBER() OVER ( PARTITION BY customer_id ORDER BY tag, id ) AS rn
                  FROM   table2 )
         PIVOT ( MAX( tag ) FOR rn IN ( 1 AS tag1, 2 AS tag2, 3 AS tag3, 4 AS tag4 ) )
       ) t2
       ON ( t1.customer_id = t2.customer_id );


CUSTOMER_ID
FIRSTNAME
LASTNAME
TAG1
TAG2
TAG3
TAG4


1
ALICE
MILLER
ADMIN
PRO-CUSTOMER
null
null

2
BOB
SMITH
PRO CUSTOMER
null
null
null

CUSTOMER_ID	FIRSTNAME	LASTNAME	TAG1	TAG2	TAG3	TAG4
1	ALICE	MILLER	ADMIN	PRO-CUSTOMER	null	null
2	BOB	SMITH	PRO CUSTOMER	null	null	null