I have a query I want to run using DBQwiksite siftware, which produces
[microsoft][odbc microsoft access driver] syntax error (missing
operator) in query expression
error when you go to save it.
The query I want to run is this:
SELECT m1.start_date, m1.end_date, m1.start_time, m1.end_time,
m1.match_id, t1.team_name AS team1_name, t2.team_name AS team2_name,
s1.stadium_name AS stadium, type.type_title as type,
channels.channel_name as channels
FROM matches AS m1
LEFT JOIN teams AS t1 ON m1.team1_id = t1.team_id
LEFT JOIN teams AS t2 ON m1.team2_id = t2.team_id
LEFT JOIN stadiums AS s1 ON m1.stadium_id = s1.stadium_id
LEFT JOIN type AS type ON m1.matches_sport_id = ...