2 # Testing Left Join on three tables with All Datatypes.
3 # select t1.f1, t1.f2, t2.f1, t2.f2, t3.f1, t3.f2 from t1 inner join t2 on t1.f1 = t2.f1 inner join t3 on t2.f1 = t3.f1 inner join t1 on t3.f1 = t1.f1;
5 CREATEFILE
=${PWD}/sql
/Join
/dropt1t2.sql
7 if [ -s "$CREATEFILE" ]
9 REL_PATH
=`pwd`/sql
/Join
12 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/alldatatype.sql
15 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/drop_t1_t2_t3.sql
19 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/inner_t1_t2_t3_t1.sql
22 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/drop_t1_t2_t3.sql
26 $CSQL_INSTALL_ROOT/bin
/csql
-s ${REL_PATH}/drop_t1_t2_t3.sql