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.
Search found 2 matches
- Thu Feb 05, 2015 1:24 pm
- Forum: Databases
- Topic: Three tables linked via JOIN
- Replies: 3
- Views: 3840
- Thu Feb 05, 2015 12:04 pm
- Forum: Databases
- Topic: Three tables linked via JOIN
- Replies: 3
- Views: 3840
Three tables linked via JOIN
Hey, when joining multiple tables in SQL JOIN, an error occurs. syntax to use near '((FROM SeznamHW... MySQL put "SELECT * ((FROM SeznamHW JOIN Firmy ON Firmy.ID = SeznamHW.IDFirma) JOIN Pracoviste ON Pracoviste.ID = SeznamHW.ID-Pracoviste)" into tSQL put revDataFromQuery(tab, cr, gConnectionID, tSQ...