1 echo select * from t11
,t12
,t13 where t12.f1
=t13.f8 and t13.f7
=t11.f1
;
2 ---------------------------------------------------------
3 t11.f1 t11.f2 t11.f3 t11.f4 t11.f5 t12.f1 t12.f2 t12.f3 t13.f7 t13.f8
4 ---------------------------------------------------------
5 2 Y sales
6000 20 20 HR CTC
2 20
7 echo select * from t11
,t12
,t13 where t12.f1
=t13.f8 or t13.f7
=t11.f1
;
8 ---------------------------------------------------------
9 t11.f1 t11.f2 t11.f3 t11.f4 t11.f5 t12.f1 t12.f2 t12.f3 t13.f7 t13.f8
10 ---------------------------------------------------------
11 1 X IT
5000 10 10 IT BBSR
1 50
12 1 X IT
5000 10 20 HR CTC
2 20
13 1 X IT
5000 10 20 HR CTC
1 50
14 1 X IT
5000 10 30 R
&D DELHI
1 50
15 2 Y sales
6000 20 10 IT BBSR
2 20
16 2 Y sales
6000 20 20 HR CTC
2 20
17 2 Y sales
6000 20 30 R
&D DELHI
2 20
18 3 Z IT
7000 10 20 HR CTC
2 20