These are the tables I use
// tbl_Wedstrijden
cSQL := '';
cSQL := cSQL + 'CREATE TABLE tbl_Wedstrijden ';
cSQL := cSQL + '(';
cSQL := cSQL + 'Wed_ID Word,';
cSQL := cSQL + 'Wed_Seizoen_ID Word,';
cSQL := cSQL + 'Wed_Datum Date,';
cSQL := cSQL + 'Wed_Tijd Time,';
cSQL := cSQL + 'Wed_Plaats Word,';
cSQL := cSQL + 'Wed_TeamA Word,';
cSQL := cSQL + 'Wed_TeamB Word,';
cSQL := cSQL + 'Wed_Scheids_1 Word,';
cSQL := cSQL + 'Wed_Scheids_2 Word,';
cSQL := cSQL + 'Wed_Scheids_3 Word,';
cSQL := cSQL + 'Wed_Scheids_4 Word,';
cSQL := cSQL + 'Wed_Divisie Word,';
cSQL := cSQL + 'Wed_Begeleiding Boolean,';
cSQL := cSQL + 'Wed_SPV_ID Word,';
cSQL := cSQL + 'Wed_Opmerkingen varchar, ';
cSQL := cSQL + 'Wed_Meetellen Boolean,';
cSQL := cSQL + 'Wed_Show Boolean,';
cSQL := cSQL + 'Wed_Outlook Boolean';
cSQL := cSQL + ');';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
// tbl_Divisies
cSQL := '';
cSQL := cSQL + 'CREATE TABLE tbl_Divisie ';
cSQL := cSQL + '(';
cSQL := cSQL + 'Divisie_ID Word,';
cSQL := cSQL + 'Divisie_Tekst varchar(25),';
cSQL := cSQL + 'Divisie_Gebruiken Boolean,';
cSQL := cSQL + 'Divisie_Volgorde Word,';
cSQL := cSQL + 'Divisie_Voluit varchar(75),';
cSQL := cSQL + 'Divisie_Vergoeding Float';
cSQL := cSQL + ');';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
// tbl_Evaluatie_Linesman
cSQL := '';
cSQL := cSQL + 'CREATE TABLE tbl_Evaluatie_Linesman ';
cSQL := cSQL + '(';
cSQL := cSQL + 'Evo_ID Word,';
cSQL := cSQL + 'Evo_Scheids_ID Word,';
cSQL := cSQL + 'Evo_Wed_ID Word,';
cSQL := cSQL + 'Evo_Systeem Word,';
cSQL := cSQL + 'Evo_SoortWedstrijd Word,';
cSQL := cSQL + 'Evo_Supervisor Word,';
cSQL := cSQL + 'Evo_Goal_TeamA_Per1 Word,';
cSQL := cSQL + 'Evo_Goal_TeamA_Per2 Word,';
cSQL := cSQL + 'Evo_Goal_TeamA_Per3 Word,';
cSQL := cSQL + 'Evo_Goal_TeamA_Per4 Word,';
cSQL := cSQL + 'Evo_Goal_TeamB_Per1 Word,';
cSQL := cSQL + 'Evo_Goal_TeamB_Per2 Word,';
cSQL := cSQL + 'Evo_Goal_TeamB_Per3 Word,';
cSQL := cSQL + 'Evo_Goal_TeamB_Per4 Word,';
cSQL := cSQL + 'Evo_Straf_TeamA_Per1 Word,';
cSQL := cSQL + 'Evo_Straf_TeamA_Per2 Word,';
cSQL := cSQL + 'Evo_Straf_TeamA_Per3 Word,';
cSQL := cSQL + 'Evo_Straf_TeamA_Per4 Word,';
cSQL := cSQL + 'Evo_Straf_TeamB_Per1 Word,';
cSQL := cSQL + 'Evo_Straf_TeamB_Per2 Word,';
cSQL := cSQL + 'Evo_Straf_TeamB_Per3 Word,';
cSQL := cSQL + 'Evo_Straf_TeamB_Per4 Word,';
cSQL := cSQL + 'Evo_Fitheid Word,';
cSQL := cSQL + 'Evo_Tekens Word,';
cSQL := cSQL + 'Evo_Positie_Eindvak Word,';
cSQL := cSQL + 'Evo_FaceOffs Word,';
cSQL := cSQL + 'Evo_GameManagement Word,';
cSQL := cSQL + 'Evo_Aanwezigheid Word,';
cSQL := cSQL + 'Evo_Oplettendheid Word,';
cSQL := cSQL + 'Evo_Communicatie Word,';
cSQL := cSQL + 'Evo_Teamwork Word,';
cSQL := cSQL + 'Evo_Standaard_Per1 Word,';
cSQL := cSQL + 'Evo_Standaard_Per2 Word,';
cSQL := cSQL + 'Evo_Standaard_Per3 Word,';
cSQL := cSQL + 'Evo_Standaard_Per4 Word,';
cSQL := cSQL + 'Evo_Straffen_Gemist Word,';
cSQL := cSQL + 'Evo_Straffen_Cheap Word,';
cSQL := cSQL + 'Evo_Icings_Gemist Word,';
cSQL := cSQL + 'Evo_Icings_Twijfel Word,';
cSQL := cSQL + 'Evo_SterkePunten varchar,';
cSQL := cSQL + 'Evo_VerbeterPunten varchar,';
cSQL := cSQL + 'Evo_Feedback varchar';
cSQL := cSQL + ');';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
// tbl_Evaluatie_Referee
cSQL := '';
cSQL := cSQL + 'CREATE TABLE tbl_Evaluatie_Referee ';
cSQL := cSQL + '(';
cSQL := cSQL + 'Evo_ID Word,';
cSQL := cSQL + 'Evo_Scheids_ID Word,';
cSQL := cSQL + 'Evo_Wed_ID Word,';
cSQL := cSQL + 'Evo_Systeem Word,';
cSQL := cSQL + 'Evo_SoortWedstrijd Word,';
cSQL := cSQL + 'Evo_Supervisor Word,';
cSQL := cSQL + 'Evo_Goal_TeamA_Per1 Word,';
cSQL := cSQL + 'Evo_Goal_TeamA_Per2 Word,';
cSQL := cSQL + 'Evo_Goal_TeamA_Per3 Word,';
cSQL := cSQL + 'Evo_Goal_TeamA_Per4 Word,';
cSQL := cSQL + 'Evo_Goal_TeamB_Per1 Word,';
cSQL := cSQL + 'Evo_Goal_TeamB_Per2 Word,';
cSQL := cSQL + 'Evo_Goal_TeamB_Per3 Word,';
cSQL := cSQL + 'Evo_Goal_TeamB_Per4 Word,';
cSQL := cSQL + 'Evo_Straf_TeamA_Per1 Word,';
cSQL := cSQL + 'Evo_Straf_TeamA_Per2 Word,';
cSQL := cSQL + 'Evo_Straf_TeamA_Per3 Word,';
cSQL := cSQL + 'Evo_Straf_TeamA_Per4 Word,';
cSQL := cSQL + 'Evo_Straf_TeamB_Per1 Word,';
cSQL := cSQL + 'Evo_Straf_TeamB_Per2 Word,';
cSQL := cSQL + 'Evo_Straf_TeamB_Per3 Word,';
cSQL := cSQL + 'Evo_Straf_TeamB_Per4 Word,';
cSQL := cSQL + 'Evo_Fitheid Word,';
cSQL := cSQL + 'Evo_Tekens Word,';
cSQL := cSQL + 'Evo_Positie_Eindvak Word,';
cSQL := cSQL + 'Evo_Positie_Spel Word,';
cSQL := cSQL + 'Evo_GameManagement Word,';
cSQL := cSQL + 'Evo_Aanwezigheid Word,';
cSQL := cSQL + 'Evo_Oplettendheid Word,';
cSQL := cSQL + 'Evo_Communicatie Word,';
cSQL := cSQL + 'Evo_Teamwork Word,';
cSQL := cSQL + 'Evo_Standaard_Per1 Word,';
cSQL := cSQL + 'Evo_Standaard_Per2 Word,';
cSQL := cSQL + 'Evo_Standaard_Per3 Word,';
cSQL := cSQL + 'Evo_Standaard_Per4 Word,';
cSQL := cSQL + 'Evo_Straffen_Gemist Word,';
cSQL := cSQL + 'Evo_Straffen_Cheap Word,';
cSQL := cSQL + 'Evo_Icings_Gemist Word,';
cSQL := cSQL + 'Evo_Icings_Twijfel Word,';
cSQL := cSQL + 'Evo_SterkePunten varchar,';
cSQL := cSQL + 'Evo_VerbeterPunten varchar,';
cSQL := cSQL + 'Evo_Feedback varchar';
cSQL := cSQL + ');';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
// tbl_IJsbanen
cSQL := '';
cSQL := cSQL + 'CREATE TABLE tbl_IJsbanen ';
cSQL := cSQL + '(';
cSQL := cSQL + 'IJS_ID Word,';
cSQL := cSQL + 'IJS_Plaats varchar(50),';
cSQL := cSQL + 'IJS_Kilometers Word,';
cSQL := cSQL + 'IJS_Naam varchar(50),';
cSQL := cSQL + 'IJS_Parkeren Float';
cSQL := cSQL + ');';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
// tbl_Licenties aanmaken
cSQL := '';
cSQL := cSQL + 'CREATE TABLE tbl_Licenties ';
cSQL := cSQL + '(';
cSQL := cSQL + 'Fluit_ID Word,';
cSQL := cSQL + 'Fluit_Seizoen_ID Word,';
cSQL := cSQL + 'Fluit_Scheids_ID Word,';
cSQL := cSQL + 'Fluit_Licentie_ID Word,';
cSQL := cSQL + 'Fluit_Cursus Boolean,';
cSQL := cSQL + 'Fluit_Opmerking varchar,';
cSQL := cSQL + 'Fluit_Vergoeding Boolean,';
cSQL := cSQL + 'Fluit_Bedrag Float';
cSQL := cSQL + ');';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
// tbl_Licenties_Keuze aanmaken
cSQL := '';
cSQL := cSQL + 'CREATE TABLE tbl_Licenties_Keuze ';
cSQL := cSQL + '(';
cSQL := cSQL + 'Licentie_ID Word,';
cSQL := cSQL + 'Licentie varchar(10),';
cSQL := cSQL + 'Licentie_Uitleg varchar(250)';
cSQL := cSQL + ');';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
// tbl_Licenties_Keuze vullen met de juiste licenties
cSQL := '';
cSQL := cSQL + 'INSERT INTO tbl_Licenties_Keuze ';
cSQL := cSQL + 'VALUES (1,"-","Geen licentie aangevraagd")';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
cSQL := '';
cSQL := cSQL + 'INSERT INTO tbl_Licenties_Keuze ';
cSQL := cSQL + 'VALUES (2,"A","Ere Divisie")';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
cSQL := '';
cSQL := cSQL + 'INSERT INTO tbl_Licenties_Keuze ';
cSQL := cSQL + 'VALUES (3,"B","Eerste Divisie")';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
cSQL := '';
cSQL := cSQL + 'INSERT INTO tbl_Licenties_Keuze ';
cSQL := cSQL + 'VALUES (4,"C","U-20")';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
cSQL := '';
cSQL := cSQL + 'INSERT INTO tbl_Licenties_Keuze ';
cSQL := cSQL + 'VALUES (5,"D","U-17")';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
cSQL := '';
cSQL := cSQL + 'INSERT INTO tbl_Licenties_Keuze ';
cSQL := cSQL + 'VALUES (6,"E","U-14")';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
cSQL := '';
cSQL := cSQL + 'INSERT INTO tbl_Licenties_Keuze ';
cSQL := cSQL + 'VALUES (7,"F","U-12")';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
cSQL := '';
cSQL := cSQL + 'INSERT INTO tbl_Licenties_Keuze ';
cSQL := cSQL + 'VALUES (8,"G","Mini/Welpen")';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
// tbl_Scheidsrechters aanmaken
cSQL := '';
cSQL := cSQL + 'CREATE TABLE tbl_Scheidsrechters ';
cSQL := cSQL + '(';
cSQL := cSQL + 'Scheids_ID Word,';
cSQL := cSQL + 'Voornaam varchar(20),';
cSQL := cSQL + 'Tussenvoegsel varchar(10),';
cSQL := cSQL + 'Achternaam varchar(50),';
cSQL := cSQL + 'Adres varchar(60),';
cSQL := cSQL + 'Postcode varchar(6),';
cSQL := cSQL + 'Woonplaats varchar(40),';
cSQL := cSQL + 'Telefoon varchar(11),';
cSQL := cSQL + 'Mobiel varchar(11),';
cSQL := cSQL + 'Geboortedatum date,';
cSQL := cSQL + 'Email varchar(250)';
cSQL := cSQL + ');';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
// tbl_Seizoenen
cSQL := '';
cSQL := cSQL + 'CREATE TABLE tbl_Seizoenen ';
cSQL := cSQL + '(';
cSQL := cSQL + 'Sei_ID Word,';
cSQL := cSQL + 'SEI_Periode varchar(9),';
cSQL := cSQL + 'Sei_Van Word,';
cSQL := cSQL + 'Sei_Tot Word,';
cSQL := cSQL + 'Sei_Selected Boolean,';
cSQL := cSQL + 'Sei_Letter Char';
cSQL := cSQL + ');';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
// tbl_Seizoenen
cSQL := '';
cSQL := cSQL + 'CREATE TABLE tbl_Supervisors ';
cSQL := cSQL + '(';
cSQL := cSQL + 'SPV_ID Word,';
cSQL := cSQL + 'SPV_Naam varchar(255),';
cSQL := cSQL + 'SPV_Volgorde Word';
cSQL := cSQL + ');';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
// tbl_Supervisors vullen met namen
cSQL := '';
cSQL := cSQL + 'INSERT INTO tbl_Supervisors ';
cSQL := cSQL + 'VALUES (1,"",1)';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
cSQL := '';
cSQL := cSQL + 'INSERT INTO tbl_Supervisors ';
cSQL := cSQL + 'VALUES (2,"Aschwin van Loon",2)';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
cSQL := '';
cSQL := cSQL + 'INSERT INTO tbl_Supervisors ';
cSQL := cSQL + 'VALUES (3,"Noud van Berkel",3)';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
cSQL := '';
cSQL := cSQL + 'INSERT INTO tbl_Supervisors ';
cSQL := cSQL + 'VALUES (4,"Guus Sijmons",4)';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
cSQL := '';
cSQL := cSQL + 'INSERT INTO tbl_Supervisors ';
cSQL := cSQL + 'VALUES (5,"Jan Passchier",5)';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
cSQL := '';
cSQL := cSQL + 'INSERT INTO tbl_Supervisors ';
cSQL := cSQL + 'VALUES (6,"Ruud van Baast",7)';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
cSQL := '';
cSQL := cSQL + 'INSERT INTO tbl_Supervisors ';
cSQL := cSQL + 'VALUES (7,"Coen Hensing",7)';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
// tbl_Teams
cSQL := '';
cSQL := cSQL + 'CREATE TABLE tbl_Teams ';
cSQL := cSQL + '(';
cSQL := cSQL + 'Team_ID Word,';
cSQL := cSQL + 'Team_Naam varchar(50),';
cSQL := cSQL + 'Team_Tonen Boolean,';
cSQL := cSQL + 'Team_Divisie Word,';
cSQL := cSQL + 'Team_Plaats varchar(50),';
cSQL := cSQL + 'Team_Alias varchar(50)';
cSQL := cSQL + ');';
SQLite3Connection_RefereeDB.ExecuteDirect(cSQL);
SQLTransaction_RefereeDB.Commit;
and these are the 2 query's you also need
// qry_Scheidsrechters
cSQL := '';
cSQL := 'SELECT '+
'Scheids_ID, REPLACE(RTRIM(COALESCE(Voornaam || " ", "") || ' +
'COALESCE(Tussenvoegsel || " ", "") || COALESCE(Achternaam, "")), '+
'" ", " ") AS Scheidsrechter ' +
'FROM ' +
'tbl_Scheidsrechters;';
SQLite3Connection_RefereeDB.ExecuteDirect('' +
'CREATE VIEW IF NOT EXISTS qry_Scheidsrechters AS ' + cSQL);
// qry_Teams
cSQL := '';
cSQL := 'SELECT '+
'Team_ID, Team_Naam AS Team, Team_Tonen AS Tonen, Team_Divisie, ' +
'Divisie_Tekst AS Divisie, Team_Alias AS Alias, Team_Plaats ' +
'FROM ' +
'tbl_Divisie INNER JOIN tbl_Teams ON tbl_Divisie.Divisie_ID = tbl_Teams.Team_Divisie ' +
'ORDER BY ' +
'Team_Naam;';
SQLite3Connection_RefereeDB.ExecuteDirect('' +
'CREATE VIEW IF NOT EXISTS qry_Teams AS ' + cSQL);