DataTables
Advanced interaction
features for your tables.
Editor
Comprehensive editing
library for DataTables.
Manual
Download
≡ Show site navigation

Editor PHP Full Join

Editor PHP Full Join

binexlinebinexline Posts: 27Questions: 10Answers: 0
in Free community support

Hello,

Is there any way to do 'full join' in Editor PHP..? It looks like I can only do left join at the moment...

This question has an accepted answers - jump to answer

Answers

  • binexlinebinexline Posts: 27Questions: 10Answers: 0

    Never mind! I created my own full join method :D

  • binexlinebinexline Posts: 27Questions: 10Answers: 0

    Actually... now I'm getting below error

    DataTables warning: table id=mainTable - Primary key element is not available in data set.

  • allanallan Posts: 64,029Questions: 1Answers: 10,555 Site admin
    Answer ✓

    You are correct - our server-side libraries only support a left join at the moment. You could use an SQL VIEW if you wanted to do some other kind of join.

    Regards,
    Allan

This discussion has been closed.

DataTables

DataTables designed and created by SpryMedia Ltd.
© 2007-2023 MIT licensed. Privacy policy. Supporters.
SpryMedia Ltd is registered in Scotland, company no. SC456502.