Table Joins

Table Joins

mikducmikduc Posts: 25Questions: 7Answers: 0

In editor - how do I join tables using multiple fields in the leftJoin function?

Replies

  • colincolin Posts: 15,112Questions: 1Answers: 2,583

    Hi @mikduc ,

    This page here should help, it discussesleftJoin in detail.

    Cheers,

    Colin

  • rf1234rf1234 Posts: 2,801Questions: 85Answers: 406

    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

This discussion has been closed.