Concat Assistance Please

Please assist with CONCAT

TABLE1
SSN
111
222
333
444

TABLE2
SSN  SQI
111  O
111  P
222  O
333  E
444  P
111  7
111  8


NEEDED RESULT
SSN  ALL SQI
111  O P 7 8
222  O
333  E
444  P



SELECT DISTINCT table1.SSN
     , table1.PCMF
     , table2.SQIEN
     , concatrelated("sqien","ssn='" & [table1]![ssn] & "'") AS SQI7
  FROM table1 
  LEFT 
  JOIN table2 
    ON table1.SSN = table2.SSN
 WHERE (((table1.PCMF)="11"))
     ;