How to use SQL INNER JOIN on Datatable post script?
How to use SQL INNER JOIN on Datatable post script?
michelmir
Posts: 16Questions: 7Answers: 0
Hello!
I have a Datatable table that display data from one table that have one column related with another table. When this Datatable table open, all records are show up but just one column display a ID number instead of name. Basically, in this case, i'm use this SQL INNER JOIN in php code:
SELECT users.*, types.type FROM users INNER JOIN types ON users.type = types.typeID
Is it possible to insert the query above inside ssp class or another script? Thnks!
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
No - the SSP class does not support joins I'm afraid. If you have a look around the forum, you'll find a few other threads on the topic - but the SSP class is really just intended to be a demo, which you can modify if you need.
The Editor PHP libraries (which are MIT licensed - only the client-side Editor needs a license) do support a LEFT JOIN with server-side processing.
Allan