php and ajax filter tables

I have a small project in php and mysql, I would like to bring the mysql records into a Datatable table (it's already done), I another select I bring 2 more select fields from other tables (it's already done).

I just need a help to build a query (select with join between 3 or more tables to bring the results in the Datatable)

thanks