Search and joins

Hi I tried to google and looked through some videos, but did not find the good explanation. I wonder if you can point me to a good video or docs that could help me to solve following:
Let's say I have table order with order number field and with foreign keys for creator(user table) and customer table.
On my frontend I will display a list of these orders where I show the name of the creator and the name of customer. Using addons I can display this data in the list.
But I would like to add the freetext search field in the frontend that will allow users to search by all of the 3 (order number, username, customer name). I am passing one input to the API.
I know how to solve this with raw SQL query, but how do I built this in Xano? How do I join the tables and apply the search in a good way? The search should be quick ofcourse.
I want the results for my listing where the search input is found in one of the fields