SELECT t.teamName as Home, t2.teamName as Away 
FROM fixtures as f 
    JOIN team as t 
       ON t.teamID = f.hometeam 
    JOIN team as t2 
       ON t2.teamID = f.awayteam 
WHERE f.hometeam = 17 or f.awayteam = 17

#
# Table structure for table `fixtures`
#

CREATE TABLE `fixtures` (
  `fixID` int(2) NOT NULL auto_increment,
  `hometeam` int(2) NOT NULL default '0',
  `awayteam` int(2) NOT NULL default '0',
  PRIMARY KEY  (`fixID`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

#
# Dumping data for table `fixtures`
#

INSERT INTO `fixtures` VALUES (1, 13, 17);
INSERT INTO `fixtures` VALUES (2, 3, 17);
INSERT INTO `fixtures` VALUES (3, 17, 16);
INSERT INTO `fixtures` VALUES (4, 81, 17);

#
# Table structure for table `team`
#

CREATE TABLE `team` (
  `teamID` int(2) NOT NULL auto_increment,
  `teamName` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`teamID`),
  UNIQUE KEY `teamName` (`teamName`)
) TYPE=MyISAM AUTO_INCREMENT=82 ;

#
# Dumping data for table `team`
#

INSERT INTO `team` VALUES (1, 'Team 1');
INSERT INTO `team` VALUES (2, 'Team 2');
INSERT INTO `team` VALUES (3, 'Team 3');
INSERT INTO `team` VALUES (4, 'Team 4');
INSERT INTO `team` VALUES (5, 'Team 5');
INSERT INTO `team` VALUES (6, 'Team 6');
INSERT INTO `team` VALUES (7, 'Team 7');
INSERT INTO `team` VALUES (8, 'Team 8');
INSERT INTO `team` VALUES (9, 'Team 9');
INSERT INTO `team` VALUES (10, 'Team 10');
INSERT INTO `team` VALUES (11, 'Team 11');
INSERT INTO `team` VALUES (12, 'Team 12');
INSERT INTO `team` VALUES (13, 'Team 13');
INSERT INTO `team` VALUES (14, 'Team 14');
INSERT INTO `team` VALUES (15, 'Team 15');
INSERT INTO `team` VALUES (16, 'Team 16');
INSERT INTO `team` VALUES (17, 'Team 17');
INSERT INTO `team` VALUES (81, 'Team 81');