left join lukt niet (Opgelost)

CREATE TABLE IF NOT EXISTS `wedstrijden` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `id_tm1` int(2) NOT NULL,
  `id_tm2` int(2) NOT NULL,
  `sub_tm` int(2) NOT NULL,
  `datum` varchar(10) NOT NULL,
  `tijd` varchar(5) NOT NULL,
  `sc_tm1` int(2) DEFAULT NULL,
  `sc_tm2` int(2) DEFAULT NULL,
  `wedstrijdbal` varchar(15) DEFAULT NULL,
  `afgelast` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

CREATE TABLE IF NOT EXISTS `wedstrijden` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `id_tm1` int(2) NOT NULL,
  `id_tm2` int(2) NOT NULL,
  `sub_tm` int(2) NOT NULL,
  `datum` varchar(10) NOT NULL,
  `tijd` varchar(5) NOT NULL,
  `sc_tm1` int(2) DEFAULT NULL,
  `sc_tm2` int(2) DEFAULT NULL,
  `wedstrijdbal` varchar(15) DEFAULT NULL,
  `afgelast` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

CREATE TABLE IF NOT EXISTS `teams` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `naam` varchar(18) NOT NULL,
  `plaats` varchar(15) NOT NULL DEFAULT 'Niet opgegeven',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;

CREATE TABLE IF NOT EXISTS `teams` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `naam` varchar(18) NOT NULL,
  `plaats` varchar(15) NOT NULL DEFAULT 'Niet opgegeven',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;

SELECT * 
FROM `wedstrijden` 
INNER JOIN `teams` 
ON wedstrijd.id_tm1=team.id

SELECT * 
FROM `wedstrijden` 
INNER JOIN `teams` 
ON wedstrijd.id_tm1=team.id

SELECT wedstrijden.id_tm1, wedstrijden.id_tm2, te.name AS team1_name, b.name AS team2_name FROM wedstrijden AS w LEFT OUTER JOIN teams AS a ON w.tm_id1 = a.id LEFT OUTER JOIN teams AS b ON w.™_id2 = b.id

SELECT wedstrijden.id_tm1, wedstrijden.id_tm2, te.name AS team1_name, b.name AS team2_name FROM wedstrijden AS w LEFT OUTER JOIN teams AS a ON w.tm_id1 = a.id LEFT OUTER JOIN teams AS b ON w.™_id2 = b.id