Pali - teniszadatok lekérdezése...

--- ALÁBBI lekérdezése

SELECT tcmt1.csb_team_id AS team_id1, tcmt2.csb_team_id AS team_id2, tcm.id AS match_id
FROM  `ttnsc_csb_match` AS tcm
INNER JOIN  `ttnsc_csb_match_team` AS tcmt1 ON tcm.id = tcmt1.csb_match_id
INNER JOIN  `ttnsc_csb_match_team` AS tcmt2 ON tcm.id = tcmt2.csb_match_id
AND tcmt1.csb_team_id != tcmt2.csb_team_id
GROUP BY tcm.id

----------------------------------------------------

--
-- Tábla szerkezet: `ttnsc_csb_match`
--

CREATE TABLE IF NOT EXISTS `ttnsc_csb_match` (
  `id` INT(5) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- A tábla adatainak kiíratása `ttnsc_csb_match`
--

INSERT INTO `ttnsc_csb_match` (`id`) VALUES
(10),
(11);

-- --------------------------------------------------------

--
-- Tábla szerkezet: `ttnsc_csb_match_team`
--

CREATE TABLE IF NOT EXISTS `ttnsc_csb_match_team` (
  `csb_team_id` INT(5) NOT NULL,
  `csb_match_id` INT(5) NOT NULL,
  UNIQUE KEY `csb_team_id` (`csb_team_id`,`csb_match_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;

--
-- A tábla adatainak kiíratása `ttnsc_csb_match_team`
--

INSERT INTO `ttnsc_csb_match_team` (`csb_team_id`, `csb_match_id`) VALUES
(1, 10),
(1, 11),
(2, 10),
(2, 11);

-- --------------------------------------------------------

--
-- Tábla szerkezet: `ttnsc_csb_team`
--

CREATE TABLE IF NOT EXISTS `ttnsc_csb_team` (
  `id` INT(5) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- A tábla adatainak kiíratása `ttnsc_csb_team`
--

INSERT INTO `ttnsc_csb_team` (`id`, `name`) VALUES
(1, 'team1'),
(2, 'team2'),
(3, 'team3'),
(4, 'team4');

--
-- Megkötések a kiírt táblákhoz
--

--
-- Megkötések a táblához `ttnsc_csb_match_team`
--
ALTER TABLE `ttnsc_csb_match_team`
  ADD CONSTRAINT `ttnsc_csb_match_team_ibfk_1` FOREIGN KEY (`csb_team_id`) REFERENCES `ttnsc_csb_team` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;