loadRecords(sqlString) can't use SQL "JOIN"?

Classic Servoy
1

I tried to use an SQL JOIN in the sqlString in a loadRecords(sqlString), but it was silently munged into unrecognisability before getting to the SQL backend (FWIW: mysql).

The manual is silent on if I should be able to use this construcl. Bug or documentation oversight?

Thanks,
Neale.

2

That’s an undocumented restriction. Currently, you can only do SELECT … FROM … WHERE. As far as I understood, this is on the list of of future improvements.