1 Table t1 and t2 created
in target DB.
2 cachetable
-t t1
-c "t1f1<5"
3 cachetable
-t t2
-c "t2f1>15" -f "t2f1,t2f3,t2f5"
4 select query on t1 and t2 table
5 ---------------------------------------------------------
6 t1.t1f1 t1.t1f2 t1.t1f3 t1.t1f4 t1.t1f5
7 ---------------------------------------------------------
13 ---------------------------------------------------------
14 t2.t2f1 t2.t2f3 t2.t2f5
15 ---------------------------------------------------------