1 echo select * from t11
,t12 where t11.f5
=t12.f1
;
2 ---------------------------------------------------------
3 t11.f1 t11.f2 t11.f3 t11.f4 t11.f5 t12.f1 t12.f2 t12.f3
4 ---------------------------------------------------------
5 1 X IT
5000 10 10 IT BBSR
6 2 Y sales
6000 20 20 HR CTC
7 3 Z IT
7000 10 10 IT BBSR
9 echo select * from t11
,t12 where t11.f5
> t12.f1
;
10 ---------------------------------------------------------
11 t11.f1 t11.f2 t11.f3 t11.f4 t11.f5 t12.f1 t12.f2 t12.f3
12 ---------------------------------------------------------
13 2 Y sales
6000 20 10 IT BBSR
15 echo select * from t11
,t12 where t12.f1
<= t11.f5
;
16 ---------------------------------------------------------
17 t11.f1 t11.f2 t11.f3 t11.f4 t11.f5 t12.f1 t12.f2 t12.f3
18 ---------------------------------------------------------
19 1 X IT
5000 10 10 IT BBSR
20 2 Y sales
6000 20 10 IT BBSR
21 2 Y sales
6000 20 20 HR CTC
22 3 Z IT
7000 10 10 IT BBSR
24 echo select * from t11
,t12 where t12.f1
!= t11.f5
;
25 ---------------------------------------------------------
26 t11.f1 t11.f2 t11.f3 t11.f4 t11.f5 t12.f1 t12.f2 t12.f3
27 ---------------------------------------------------------
28 1 X IT
5000 10 20 HR CTC
29 1 X IT
5000 10 30 R
&D DELHI
30 2 Y sales
6000 20 10 IT BBSR
31 2 Y sales
6000 20 30 R
&D DELHI
32 3 Z IT
7000 10 20 HR CTC
33 3 Z IT
7000 10 30 R
&D DELHI
35 echo select * from t11
,t12 where t12.f1
> 20;
36 ---------------------------------------------------------
37 t11.f1 t11.f2 t11.f3 t11.f4 t11.f5 t12.f1 t12.f2 t12.f3
38 ---------------------------------------------------------
39 1 X IT
5000 10 30 R
&D DELHI
40 2 Y sales
6000 20 30 R
&D DELHI
41 3 Z IT
7000 10 30 R
&D DELHI