mysql> SELECT * FROM T_Leute INNER JOIN T_Leute_Launen ON tag; +----+---------+-------+------+--------+------------+ | Id | Name | Jahre | F_Id | F_L_id | tag | +----+---------+-------+------+--------+------------+ | 2 | Meier | 21 | 2 | 1 | 2005-05-29 | | 5 | Müller | 19 | 2 | 1 | 2005-05-29 | | 8 | Schmidt | 20 | 2 | 1 | 2005-05-29 | | 2 | Meier | 21 | 2 | 3 | 2005-01-09 | | 5 | Müller | 19 | 2 | 3 | 2005-01-09 | | 8 | Schmidt | 20 | 2 | 3 | 2005-01-09 | | 2 | Meier | 21 | 5 | 2 | 2005-03-11 | | 5 | Müller | 19 | 5 | 2 | 2005-03-11 | | 8 | Schmidt | 20 | 5 | 2 | 2005-03-11 | | 2 | Meier | 21 | 8 | 2 | 2005-05-29 | | 5 | Müller | 19 | 8 | 2 | 2005-05-29 | | 8 | Schmidt | 20 | 8 | 2 | 2005-05-29 | +----+---------+-------+------+--------+------------+ 12 rows in set (0.00 sec) OBWOHL mysql> SELECT * FROM T_Leute; +----+---------+-------+ | Id | Name | Jahre | +----+---------+-------+ | 2 | Meier | 21 | | 5 | Müller | 19 | | 8 | Schmidt | 20 | +----+---------+-------+