In editor - how do I join tables using multiple fields in the leftJoin function?
Hi @mikduc ,
This page here should help, it discussesleftJoin in detail.
leftJoin
Cheers,
Colin
Multiple fields in left join function? I don't think that this is possible with Editor. And I didn't see a hint on this in the page Colin pointed out. But do you really need a LEFT JOIN or is an INNER JOIN ok as well?
You can always do an INNER JOIN using the WHERE clause. Of course you can use multiple fields an that where clause. This thread discusses an example: https://datatables.net/forums/discussion/comment/116150/#Comment_116150
It looks like you're new here. If you want to get involved, click one of these buttons!
Replies
Hi @mikduc ,
This page here should help, it discusses
leftJoinin detail.Cheers,
Colin
Multiple fields in left join function? I don't think that this is possible with Editor. And I didn't see a hint on this in the page Colin pointed out. But do you really need a LEFT JOIN or is an INNER JOIN ok as well?
You can always do an INNER JOIN using the WHERE clause. Of course you can use multiple fields an that where clause. This thread discusses an example:
https://datatables.net/forums/discussion/comment/116150/#Comment_116150