query / joint

[Pithon Philippe]

"docs": [
      {
        "id": "...",

        "type_s": "ticket",
        "customerid_s": "100",
...
...
...
...

      },
      {
"id": "...",

        "type_s": "customer",
        "customerid_s": "100",
        "name_s": "FISHER",
...
...
...
...

      }
]

Hello,
I have two entitys :
- tickets (type_s : ticket)
- customers (type_s : customer)

I want a query to find all tickets for name customer FISHER
In doc ticket, I have id customer but not name customer...

Any ideas ??? joint ???

Thanks
Philippe