MySQL Forums
Forum List  »  Newbie

error 1064
Posted by: Phil Cour
Date: July 31, 2024 03:58AM

Hello
I encounter an error 1064 on an SQL query that I cannot resolve.
Your help is welcome !
THANKS !

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups ON wagons.id = groups.wagon_comp_id WHERE date > '2022-07-31'' at line 4

SELECT DISTINCT groups.name,groups.size,groups.pmr as has_pmr,groups.phone, trains.id AS train_id, trains.date AS train_date, wagons.term_id AS wagon_term_id
FROM mod711_comp_trains AS trains
LEFT JOIN mod711_comp_wagons AS wagons
ON trains.id = wagons.train_comp_id
LEFT JOIN mod711_comp_groups AS groups
ON wagons.id = groups.wagon_comp_id
WHERE date > '2022-07-31'

Options: ReplyQuote


Subject
Written By
Posted
error 1064
July 31, 2024 03:58AM
July 31, 2024 08:44AM
July 31, 2024 08:49AM
August 02, 2024 01:44AM
August 05, 2024 01:49AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.