4 # Testing or, and operators in join.
5 # Create t1,t2,t3 table with 5 records each.
6 # select * from t1,t2,t3 where t1.f2= t2.f2 and t1.f3 = t3.f2.
7 # select * from t1,t2,t3 where t1.f2= t2.f2 or t1.f3 = t3.f2.
9 # AUTHOR : Jitendra Lenka
11 QUITFILE
=${PWD}/sql
/Join
/quit.sql
15 REL_PATH
=`pwd`/sql
/Join
19 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/createt1t2t3.sql
> /dev
/null
2>&1
25 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/join4.sql
28 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2t3.sql
> /dev
/null
2>&1
33 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2t3.sql
> /dev
/null
2>&1