3 # Create t1,t2 table with 5 records in each.
4 # select * from t1,t2 where t1.f1 = t2.notexist
6 # AUTHOR : Jitendra Lenka
8 QUITFILE
=${PWD}/sql
/Join
/quit.sql
12 REL_PATH
=`pwd`/sql
/Join
16 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/createt1t2.sql
> /dev
/null
2>&1
24 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/join6.sql
27 $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