cache multiple database in perform join query

Question

I need to create report presentation in asp.net webform out of a table which will have approximately 14000 rows (master table)

and other foreign tables.

User can be able to filter with every column value to get the data or by combining the column values.

Value in the table will be changed every other day.

So how do i design ? Is it possible to cache the database tables and perform join query in the tables which are cached?

If so how?

If not please suggest me the way to achieve this.

Thank you.