3 # 10. Create emp table with 5 fields, and insert 3 records in it.
5 # (a)select * from t11,t12,t13 where t12.f1=t13.f8 and t13.f7=t11.f1;
6 # (b)select * from t11,t12,t13 where t12.f1=t13.f8 or t13.f7=t11.f1;
8 # AUTHOR : Jitendra Lenka
10 QUITFILE
=${PWD}/sql
/Join
/quit.sql
14 REL_PATH
=`pwd`/sql
/Join
18 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/tablet11t12t13.sql
> /dev
/null
2>&1
25 echo "select * from t11,t12,t13 where t12.f1=t13.f8 and t13.f7=t11.f1;"
27 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/join27.sql
30 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/drot11t12t13.sql
> /dev
/null
2>&1
34 echo " select * from t11,t12,t13 where t12.f1=t13.f8 or t13.f7=t11.f1;"
36 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/join28.sql
39 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt11t12t13.sql
> /dev
/null
2>&1
43 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt11t12t13.sql
> /dev
/null
2>&1