SQL problems

General discussion on all other topics under the sun.

Moderator: Renato

Post Reply
Brixhamafc
New MMEX User
Posts: 2
Joined: Tue Jul 28, 2015 4:01 pm
Are you a spam bot?: No

SQL problems

Post by Brixhamafc »

I am trying to produce some custom reports and my SQL is not that good so have looked at www.schools.com/sql as a guide. I want to produce report using more than one table but when I enter any of the JOIN statements I get a syntax error. when typing the SQL statement if the statement is correct the text of the statement turns green e.g. Select will turn green, but none of the join statements turn green which leads me to believe that I am using the wrong syntax. I therefore got SAMS Teach Yourself SQL from the library and tried their suggestion which leaves out the join statement, and the select statement contains the tables you want to open and you then use the WHERE clause to link the tables. Once again this doesn't work , again it reports syntax error. What am I doing wrong?
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: SQL problems

Post by Nikolay »

There are a lot of sql for mmex available here: https://github.com/moneymanagerex/general-reports

For better syntax highlighting use any sqlite developer.

To discuss sql is better to provide the sql code.

Regards,
Nikolay
sterling
Super MMEX User
Posts: 72
Joined: Thu Dec 11, 2014 8:40 am
Are you a spam bot?: No

Re: SQL problems

Post by sterling »

Definitely post your code that doesn't compile.  Plenty of users are also SQL programmers.
Post Reply