AOT: Filtering Data from Multiple tables

Hi to all,

Please give me the details on,

How to filter the data from multiple tables in AOT.

Thanks in Advance