3 # 6. Create t1,t2 table with 5 each records in csql database.
4 # select * from t1, notexist;
5 # select * from t1,t2 where t1.f1 = t2.notexist
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
24 echo "select * from t1,t2 where t1.f1=t2.notexist:"
25 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/join13.sql
28 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql
> /dev
/null
2>&1
32 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql
> /dev
/null
2>&1