MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Help with Moodle Mysql query
Posted by: Peter Brawley
Date: June 20, 2016 09:00AM

You appear to have started a new case Select expression right after 'Completion tracking' but not completed it, so lose that extra instance of CASE, and lose the comma just before it since the previous CASE statement is the last Select expression in your query.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Help with Moodle Mysql query
Adele Shemberger
June 15, 2016 04:22PM
Re: Help with Moodle Mysql query
Rick James
June 20, 2016 01:24AM
Re: Help with Moodle Mysql query
Peter Brawley
June 20, 2016 09:00AM
Re: Help with Moodle Mysql query
Adele Shemberger
June 20, 2016 07:59PM
Re: Help with Moodle Mysql query
Peter Brawley
June 21, 2016 11:01AM
Re: Help with Moodle Mysql query
DJ L
June 20, 2016 10:55PM
Re: Help with Moodle Mysql query
Adele Shemberger
June 21, 2016 12:03AM


Sorry, you can't reply to this topic. It has been closed.

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.