Vermischtes

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 | 
+----+---------+-------+