WHERE for joined tables

Digo

Hello!

Like in example: https://editor.datatables.net/examples/inline-editing/join.html
I need to join a table, but we need where condition. So like here in the example: how to show only locations starting with letter "L".

How can this we done?

Thanks
Digo

rf1234

https://editor.datatables.net/manual/php/conditions