Dopppelte Einträge

[DeddyH]

2 Möglichkeiten, die mir spontan einfallen (beide ungetestet):
1.

SQL-Code:

SELECT
  P1.ID_Personal, P1.Kartennummer
FROM
  Personalstatus P1
JOIN
  Personalstatus P2
  ON
    P2.Kartennummer = P1.Kartennummer
  AND
    P2.ID_Personal <> P1.ID_Personal
ORDER BY
  P1.ID_Personal, P1.Kartennummer

2.

SQL-Code:

SELECT
  P1.ID_Personal, P1.Kartennummer
FROM
  Personalstatus P1
WHERE EXISTS(
  SELECT 
    *
  FROM
    Personalstatus
  WHERE
    Kartennummer = P1.Kartennummer
  AND
    ID_Personal <> P1.ID_Personal    
  )
ORDER BY
  P1.ID_Personal, P1.Kartennummer