search for: home_teams_id

...al sports available on the internet except this one is for Rugby. The relevant tables in my database are as follows: create table teams ( id INT AUTO_INCREMENT NOT NULL, name VARCHAR(40), PRIMARY_KEY(id) ); create table games ( id INT AUTO_INCREMENT NOT NULL, date DATETIME, #Date of game home_teams_id INT, #id of home team away_teams_id INT, #id of away team home_team_score INT, #this is not meant to link to another table away_team_score INT, #this is not meant to link to another table PRIMARY_KEY (id) ); In this example the home and away team records in games are supposed to link to a tea...