Postgres DB , PHP Code , best way to use server side processing with a complicated join of tables

saroja

We are using datables for getting data from a large database with millions of records.
I am able to use a single table and get data into datatables but I want to know how to get data from multiple tables and use server side processing .
We are using Postrgres DB.
Also, how can I use a join statement to get data, we dont want to views in the DB.

Thanks,
Saroja