INSERT INTO
  t2
SELECT
  prefix,
  fname,
  lname
FROM
  t1
WHERE
  prefix || fname || lname NOT IN (
    SELECT
      prefix || fname || lname
    FROM
      t2
  );

if you have a large number of records to process I'd recommend indexing both tables on prefix || fname || lname.