3 # 4. Create t1 and t2 table with 5 records each.
4 # select t1.f1, t2.f1, t1.f2, t2.f2 from t1,t2
5 # select * from t1,t2 where t1.f1 = t2.f1 and t1.f1 >100
7 # AUTHOR : Jitendra Lenka
9 QUITFILE
=${PWD}/sql
/Join
/quit.sql
13 REL_PATH
=`pwd`/sql
/Join
17 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/createt1t2.sql
> /dev
/null
2>&1
23 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/join2.sql
26 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql
> /dev
/null
2>&1
31 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql
> /dev
/null
2>&1