SQL ERROR当我连接2个表

对不起，我修改一下。我有三个表:

events_year
•EventID
•YearID
•id

日期•YearID
•年

事件•EventID
•EventName
•EventType

我想从三个表中显示一条记录，如下所示:

事件名称-年份:马拉松- 2008

我将它链接到一个名为"members"的表，该表包含一个ID号字段(members- ID)

所以我可以将结果限制为成员id = $un(这是来自会话的用户名)

我需要连接三个表，并将结果限制为特定的ID号记录

下面是我的部分代码:

$query =    "SELECT * FROM members JOIN events_year ON members.id = events_year.id ";
            "SELECT * FROM Event JOIN events_year ON Event.EventID = events_year.EventID WHERE username = '$un'";
            "SELECT * FROM Date JOIN events_year ON Date.YearID = events_year.YearID WHERE username = '$un'";

$results = mysql_query($query)
    or die(mysql_error());
    while ($row = mysql_fetch_array($results)) {
    echo $row['Year'];
    echo " - ";
    echo $row['Event'];
    echo "<br>";
    }       

SELECT
  *
FROM
  members
INNER JOIN
  events_year ON members.id = events_year.id
INNER JOIN
  Event ON Event.EventID = events_year.EventID
INNER JOIN
  ´Date´ ON ´Date´.YearID = events_year.YearID
WHERE
  members.username = '$un'

    "SELECT * FROM members JOIN events_year ON members.id = events_year.id ";