LiveCode Forums.

Hey, when joining multiple tables in SQL JOIN, an error occurs.
syntax to use near '((FROM SeznamHW...
MySQL Thanks for your help
Vojta.

Unable to test, and only a quick glance at the code, but perhaps move FROM outside the parentheses

Parentheses are good by a SQL command that works over PhP admin in mySQL.
Join two tables with a JOIN, where they are not needed parentheses, works well.
I have not found anywhere in the documentation LiveCode example of a more tables via SQL.
Does anyone know why it does not work?
Thank you ,Vojta.

Remove all the parentheses. They mightbe needed in phpadmin but your SELECT statement is invalid when executed as is..