3 # Create t1(6 rec),t2(6 rec),t3(6 rec),t4(2 rec),t5(2 rec) table.
4 # Select * from t1,t2,t3,t4,t5;
5 # select * from t1,t2 where t1.f1>100;
7 # AUTHOR : Jitendra Lenka
9 QUITFILE
=${PWD}/sql
/Join
/quit.sql
13 REL_PATH
=`pwd`/sql
/Join
16 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/createt1t2t3t4t5.sql
> /dev
/null
2>&1
22 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/join3.sql
25 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2t3t4t5.sql
> /dev
/null
2>&1
30 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2t3t4t5.sql
> /dev
/null
2>&1