3 # Create t11 table with 5 fields & t12 table with 3 fields and insert 3 records in each.
4 #(a)select * from t11,t12 where t11.f5=t12.f1;
5 #(b)select * from t11,t12 where t11.f5 > t12.f1;
6 #(c) select * from t11,t12 where t12.f1 <= t11.f5;
7 #(d)select * from t11,t12 where t12.f1 != t11.f5;
8 #(e)select * from t11,t12 where t12.f1 > 20;
10 # AUTHOR : Jitendra Lenka
12 QUITFILE
=${PWD}/sql
/Join
/quit.sql
16 REL_PATH
=`pwd`/sql
/Join
20 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/tablet11t12.sql
> /dev
/null
2>&1
29 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/join8.sql
32 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt11t12.sql
> /dev
/null
2>&1
38 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt11t12.sql
> /dev
/null
2>&1