join with multicolumn selector

Mike Storey

I have a need to do an join, where id=value and tag=0, but the ->leftJoin method does not appear to support the "and" operator in the where clause. Is there another way to accomplish this? (Sorry, new to PDO)

allan

Unfortunately no - sorry. The PHP and .NET libraries currently can do a join on a single option only. Would adding where condition on tag=0 match what you need? It isn't quite the same thing, but it might work for you?

Allan

numberone

I have a new php library. This might work for you if you interest.

https://github.com/n1crack/Datatables