Stand weergeven met data uit verschillende tabellen.

CREATE TABLE `competitions` (
`c_id` int(11) not null auto_increment primary key,
`c_start_date` int(11) not null default 0,
`c_end_date` int(11) not null default 0
) TYPE=MyISAM;

CREATE TABLE `competitors` (
`cp_id` int(11) not null auto_increment primary key,
`cp_first_name` varchar(25) not null default '',
`cp_last_name` varchar(30) not null default ''
) TYPE=MyISAM;

CREATE TABLE `matches` (
`m_id` int(11) not null auto_increment primary key,
`m_home_player` int(11) not null default 0,
`m_home_score` int(1) not null default 0,
`m_away_player` int(11) not null default 0,
`m_away_score` int(1) not null default 0,
`m_date` int(11) not null default 0,
`m_c_id` int(11) not null default 0
) TYPE=MyISAM;