Server Side Processing where it fetch data from multiple tables from database

rohit.bind

Hi,
Our team is trying to use datatable in our project where it is fecting the data from multiple table from database we are using join which is taking lot of time. So now we are using nested query but the challenge is sorting and searching from database table is having issue.
Please help if someone can help on this.