3 # 2. Create t1,t2 table with 5 each records in csql database.
4 # Select * from t1,t2 where where t1.f1 >100
5 # select * from t1, t2 where t1.f1 >100 or t2.f1 <100
8 # AUTHOR : Jitendra Lenka
10 QUITFILE
=${PWD}/sql
/Join
/quit.sql
14 REL_PATH
=`pwd`/sql
/Join
17 echo "select * from t1,t2 where t1.f1>100:"
18 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/createt1t2.sql
> /dev
/null
2>&1
24 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/join4.sql
27 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql
> /dev
/null
2>&1
31 echo "select * from t1,t2 where t1.f1>100 or t2.f1<100:"
33 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/join5.sql
36 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql
> /dev
/null
2>&1
41 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql
> /dev
/null
2>&1