> table: locations
> fields: location_id (primary key), location_name
> example data: 1, Lisbon; 2, Porto
>
> table: teams
> fields: team_id (primary key), team_name
> example data: 1, France; 2, England
>
> table: matches
> fields: match_id, match_datetime, match_location (foreign key to locations
Hi, I'd be grateful if someone could help me and tell me what I'm doing wrong with my
query. I suspect the answer is simple but I'm suffering a mental block right now.
In basic terms, I have three tables.
Two are reference tables thus:
table: locations
fields: location_id (primary key),
